Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “gypsters” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

173 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
gypsters143402(None) 
gypster1333951gypster_
gagsters10317082gagsters
gasters85624302g_asters
glisters93912602glisters
gristers94013412gristers
gyppers15235502gyp_pers
gypsies1335952gypsie_s
hipsters13268792hipsters
oysters103411692oy_sters
tapsters10318802tapsters
tipsters10278522tipsters
xysters17307162xy_sters
asters65631603__asters
basters94930313_basters
bisters93922613_bisters
blasters104116143blasters
blisters104015083blisters
blusters104413893blusters
boasters103915663boasters
bolsters103712453bolsters
boosters104013453boosters
bursters1038983bursters
busters94724133_busters
casters94729903_casters
clusters102912403clusters
clysters13227843clysters
coasters104317343coasters
copters113621283cop_ters
costers94128343_costers
cyphers17316753cyp_hers
cytasters1483673cytasters
dabsters1137053dabsters
dempsters1435273dempsters
diasters92913183diasters
diesters92513603diesters
dopesters1237283dopesters
dumpsters1453743dumpsters
dusters84918363_dusters
easters75125683_easters
esters64627733__esters
feasters11511563feasters
festers104121393_festers
fibsters13126413fibsters
flusters113811503flusters
fosters104220103_fosters
gagster9317633gagster_
gaiters83516543g_aiters
gamesters1236743gamesters
gangsters11205733gangsters
ganisters10248313ganisters
gapers94520473gap__ers
garters84218253g_arters
gaspers105014133g_aspers
gassers84714633g_assers
gaster75027353g_aster_
gaters74728643g__aters
gestes75721393g_este_s
getters84216103g_etters
geysers1135703geys_ers
gippers123212083gip_pers
gipsies1039903gipsie_s
glistens9366593glistens
glister84013343glister_
glitters93710543glitters
gloaters9288863gloaters
glossers9319053glossers
goiters84014443g_oiters
gophers1338983gop_hers
grafters12409193grafters
granters93614153granters
graspers11338403graspers
graters85419743g_raters
greeters92610123greeters
grifters12389233grifters
grister83915413grister_
gritters94210633gritters
grossers94410973grossers
grouters95910093grouters
grunters9359043grunters
guessers9174903guessers
gushers113512513g_ushers
gutters83715513g_utters
gyplures14102153gyplures
gypper14347293gyp_per_
gypseous1462553gypseous
gypsied1443273gypsie_d
gypsums1541923gyps_ums
gyrates113610263gyrate_s
gyrators1246003gyrators
hamsters13710423hamsters
heisters113413133heisters
hipster12288783hipster_
hoisters113513493hoisters
holsters113211943holsters
hoopsters1445693hoopsters
hypers144811913hyp__ers
imposters13347343imposters
imputers1235823imputers
jesters144118193_jesters
jousters153210423jousters
justers143815733_justers
keesters12319593keesters
keisters123212043keisters
keysters15326333keysters
kiesters123310153kiesters
klisters123910483klisters
lamsters1099753lamsters
lapsers93911053laps_ers
lasters75627693_lasters
leisters83312823leisters
listers74026533_listers
lobsters10268743lobsters
lusters73921443_lusters
masters94628923_masters
meisters103313843meisters
minsters103813923minsters
misters93927513_misters
mobsters12359063mobsters
monsters103314553monsters
munsters104010553munsters
musters94522513_musters
mystery15436523my_stery
nesters74422793_nesters
oldsters996733oldsters
ousters74122793_ousters
oyster94111703oy_ster_
pasters94531733_pasters
paters84935843__paters
pensters103012123pensters
pesters93827093_pesters
peters86624593__peters
piasters102912813piasters
plasters103518133plasters
posters93928013_posters
presters103419003presters
punsters103310583punsters
questers17168773questers
quipsters2043593quipsters
rasters74629023_rasters
resters74130403_resters
roasters83615933roasters
roisters83615563roisters
roosters83514673roosters
rosters73727553_rosters
rousters84315683rousters
roysters113610533roysters
shysters14106463shysters
sisters73721593_sisters
syphers15317273syp_hers
systems1234683sy_stems
tapster9299273tapster_
tasters74225643_tasters
testers74124543_testers
tipster9299053tipster_
toasters83912723toasters
trusters83112263trusters
trysters11298373trysters
twisters11268173twisters
ulsters72711983_ulsters
upsteps1133743_upsteps
upstirs935293_upstirs
waisters113811523waisters
wasters104026593_wasters
websters1335803websters
westers105221963_westers
wresters112711733wresters
xyster16366803xy_ster_
yatters103914623_yatters
yester93417983_yester_
yestern10338643_yestern
zesters163517293_zesters
zosters163015413_zosters

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.423422437.4
2DLD Change Limit1461621736.70321805.5
3Display Results1731730.0762276.3
 (SQL Overall)1786911737.20224811.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.