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 “wants” with Change Limit: [1] [2]

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

302 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
wants8793221(None) 
ants47243471_ants
cants77036941cants
hants86335401hants
pants76536921pants
rants55935341rants
wafts116920551wafts
waits88333521waits
wands96425481wands
wanes85040881wanes
wanks126124481wanks
wans76452271wan_s
want76156171want_
warts814840401warts
wasts87433671wasts
wats77555881wa_ts
watts86923091watts
wonts87621541wonts
acts66929862_acts
aits46355532_aits
alants67722022alants
alts46639902_alts
anas46649862_anas
ands57833612_ands
anes45255932_anes
anis45746462_anis
ant37270792_ant_
anta46839582_anta
antas55432032_antas
ante46538902_ante
antes56334322_antes
anti45536362_anti
antis55033312_antis
antsy85712792_antsy
anus47131112_anus
arts49650262_arts
aunts55227632aunts
awaits96411952awaits
awns75324432awn_s
bahts105617802bahts
baits76630582baits
bands85233432bands
banes74945582banes
bangs85627782bangs
banks115527902banks
banns75321232banns
bans66555142ban_s
banty106624002banty
basts75936932basts
bats66962332ba_ts
batts76727562batts
bents76033692bents
bints76130182bints
brants85723052brants
bunts75729802bunts
bwanas1157442bwanas
canes75350372canes
cans65050852can_s
canst74932212canst
cant66362032cant_
canto74931012canto
cantos84826972cantos
cantus85117762cantus
canty105226802canty
carts78946292carts
casts77237792casts
cats66356342ca_ts
cents74730332cents
chants115020392chants
cunts76125122cunts
dangs75623212dangs
dans56748152dan_s
darts67635732darts
daunts75014082daunts
dauts67822242dauts
dawts97216122dawts
dents65031802dents
dints67431312dints
dunts65828412dunts
easts57530322easts
eats47054872ea_ts
facts107021892facts
faints94818782faints
fanes84639892fanes
fangs96224082fangs
fanos85926502fanos
fans76247372fan_s
farts88336842farts
fasts86429682fasts
fats76252502fa_ts
fonts86124752fonts
gaits65726012gaits
gangs76222582gangs
gasts66628632gasts
gats56753442ga_ts
gents65729612gents
giants74713502giants
gnats65217712gnats
grants73722472grants
haets86525122haets
hafts116219462hafts
haints94417582haints
halts85230102halts
hands95327382hands
hangs95726732hangs
hanks126226862hanks
hant75461592hant_
harts88441592harts
hats76858252ha_ts
haunts95614392haunts
hents87330742hents
hints87330622hints
hunts86826172hunts
janes124928122janes
janty156816962janty
jaunts137511882jaunts
kanas95326912kanas
kanes95529372kanes
karts97630112karts
kats85944332ka_ts
lands65426902lands
lanes54946792lanes
lasts57731262lasts
lats45962702la_ts
lints57137192lints
lunts55826902lunts
malts76331752malts
manas76240432manas
manats84623462manats
manes76648962manes
manos74933622manos
mans66354552man_s
manta75629912manta
mantas85725362mantas
mantes84430782mantes
mantis83926032mantis
manus75924932manus
marts77442232marts
masts77035762masts
mats65460292ma_ts
matts76829182matts
mauts75927192mauts
mints76834042mints
nanas55928632nanas
nans46139402nan_s
oasts56529182oasts
oats46554212oa_ts
pacts95125802pacts
paints85921832paints
panes76148692panes
pangs84628672pangs
pans65855732pan_s
pant66061262pant_
panto76129412panto
pantos85222742pantos
panty105929302panty
parts77743372parts
pasts75936502pasts
pats66460852pa_ts
pints75936222pints
plants84921802plants
punts75828002punts
qanats154112812qanats
qats135331342qa_ts
quants153614142quants
rafts87820632rafts
rands65930452rands
ranis55235832ranis
ranks95225732ranks
rant45864682rant_
rats46260372ra_ts
rents55935182rents
runts55927632runts
saints65122422saints
salts55431882salts
sands65228582sands
sanes55649072sanes
sans45153362san_s
santo56227282santo
santos64421832santos
scants85219722scants
slants64819082slants
swanks134811562swanks
swans84625012swan_s
swats85726862swa_ts
tacts76524122tacts
taints64520532taints
tangs65028362tangs
tanks94624742tanks
tans46154832tan_s
tanto55724952tanto
tarts57242022tarts
tats46858132ta_ts
taunts65715662taunts
tauts56125512tauts
tents56434212tents
tints56030922tints
twangs10358102twangs
twats86616602twa_ts
vanes85130972vanes
vangs96319592vangs
vans76236732van_s
vasts86423772vasts
vats76841742va_ts
vaunts95212622vaunts
vents86125932vents
wabs97337232wa_bs
wacks146626282wacks
wades95634142wades
wadis95223962wadis
wads87343142wa_ds
waes76048602wa_es
waffs146315472waffs
waft106139002waft_
wages95330932wages
wags86140552wa_gs
waifs115719872waifs
wails86631482wails
wains86930872wains
wairs86424062wairs
waist86132382waist
waists97415452waists
wait75553692wait_
wakes126633652wakes
wales86142832wales
walks126218502walks
walls85529382walls
walnuts1033842walnuts
waltz17615472waltz
wames106432802wames
wamus105514682wamus
wan66761942wan__
wand85833882wan_d
wane76344722wan_e
waned95831782waned
waney115120322waney
wank115632512wan_k
wanly115118022wanly
wanted104319722wanted
wanter94423052wanter
wanters104420092wanters
wanton94413812wanton
wantons103713012wantons
wany106432362wan_y
waps96642082wa_ps
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802wa_rs
wart77866082wart_
warty119323822warty
was68767562wa__s
wasps106714692wasps
wast75655852wast_
waste86125052waste
wastes96224882wastes
wat67378922wa_t_
watt75545412wa_tt
wauks125515162wauks
wauls86120552wauls
waves115633922waves
wawls115416472wawls
waws106834902wa_ws
waxes155825502waxes
ways107737952wa_ys
weans85326742wean_s
weets85427722weets
wefts116715492wefts
welts85225192welts
wends95822812wends
wens76337932wen_s
went76051872went_
wests85727002wests
wets75940292w_ets
whangs13439722whangs
whats117718992whats
whets115019612whets
whits115923822whits
wilts85023502wilts
winds95425602winds
wines85546862wines
wings95727242wings
winks125325432winks
winos84625042winos
wins75949172win_s
wists86728522wists
wits76044872w_its
wonks124818342wonks
wons74942042won_s
wont75842502wont_
worts88631182worts
wots76342892w_ots
wrangs104611912wrangs
writs86624382writs
wynds126310372wynds
wynns11517472wynns
wyns105717032wyn_s
yangs95618702yangs
yanks125316572yanks

Search took 3 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 Filter178691538000.296603685.8
2DLD Change Limit538003021.61033416.1
3Display Results3023020.0803775.0
 (SQL Overall)1786913021.98689975.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.