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 “wrens” 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.

172 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
wrens8501624(None) 
brens75823361brens
weens85224051weens
wens76337931w_ens
whens114618761whens
wren78221681wren_
amens75624842amens
areas55935772areas
arena55323812arena
arenas65021992arenas
arene55329412arene
arenes64928392arenes
ares45871022are_s
arpens84814822arpens
avens86419332avens
bens65945702_bens
brans75437432brans
brees75632552brees
bren65629562bren_
brent75734132brent
brents84717272brents
brews105617072brews
brins75533972brins
creds85418772creds
cress75022832cress
crews105917502crews
dens55945072_dens
drees65628522drees
dregs76114862dregs
dreks105714752dreks
dress65319832dress
ens37245922__ens
ernes55224812ernes
erns45428232er_ns
evens84817102evens
fens76139762_fens
ferns85220082ferns
frees86131392frees
frena85915272frena
frets85523402frets
frons86124042frons
gens55740072_gens
glens66519852glens
grans64832542grans
greens75716872greens
grees65132472grees
greys96614852greys
grins65427222grins
hens75642572_hens
herns84825582herns
ires45639282ire_s
irons55324132irons
keens95721182keens
kens85435232_kens
kerns94719562kerns
lens46146492_lens
liens56525502liens
miens76118302miens
omens75618962omens
opens76118552opens
ores46056682ore_s
ovens86217452ovens
peens76428192peens
pens65649642_pens
preens85020112preens
prees75937172prees
preps96220692preps
press75425952press
preys105717782preys
rebs65733562_rebs
recs65734182_recs
reds56042862_reds
rees45364192_rees
refs75732242_refs
regs55436572_regs
reins56234562_reins
reis45343232_reis
rems66237722_rems
rend56136572_rend
rends65129952_rends
rent46661242_rent
rents55935182_rents
reps65937952_reps
res35565042_re_s
rets45352562_rets
revs75027052_revs
rins46153192_rins
runs46438082_runs
sirens65318152sirens
syrens94911992syrens
teens56227482teens
tens45647412_tens
terns55226872terns
thens85921832thens
trans54933042trans
treens65317872treens
trees55835762trees
treks96016852treks
trend64817452trend
trends75513542trends
tres46542902tre_s
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
triens65417542triens
tweens9489842tweens
ureas55826012ureas
urns46323902ur_ns
waes76048602wae_s
wains86930872wains
wakens135012042wakens
wanes85040882wanes
wans76452272w_ans
wardens113711902wardens
wares88250582ware_s
warns87231002warns
warrens103810892warrens
weans85326742weans
webs96622122w_ebs
weds86628932w_eds
weeds95222212weeds
weeks125017862weeks
ween75835462ween_
weensy12416822weensy
weeny115316162weeny
weeps104120562weeps
wees76249122w_ees
weets85427722weets
wen66249602w_en_
wend85330452w_end
wends95822812w_ends
went76051872w_ent
wets75940292w_ets
wheens124610612wheens
when105723042when_
whenas124610462whenas
whets115019612whets
whews145114492whews
wheys145911552wheys
whins114922332whins
widens106212722widens
wines85546862wines
wins75949172w_ins
wirers94617892wirers
wires86034912wire_s
wizens186110262wizens
woes76440662woe_s
wons74942042w_ons
worsens104610262worsens
wovens12449832wovens
wrang94716112wrang
wrangs104611912wrangs
wraps105617152wraps
wreak125513272wreak
wreaks134711112wreaks
wreck144611042wreck
wrecks15418882wrecks
wrench14439352wrench
wrest84925432wrest
wrests95313082wrests
wries85827742wries
wring95920712wring
wrings104012972wrings
writs86624382writs
wrong94712322wrong
wrongs10338932wrongs
wrung9549802wrung
wyes105727502wye_s
wynns11517472wynns
wyns105717032w_yns
yens75832262_yens

Search took 2 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.346516448.0
2DLD Change Limit538001721.51335558.5
3Display Results1721720.0503440.0
 (SQL Overall)1786911721.90993604.5
 
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.