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

243 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
legacy125665(None) 
delegacy1543532delegacy
elegancy1444382elegancy
lacy95829632l__acy
leach105422522le_ach
leachy14419732le_achy
leady95618602le_ady
leafy116316212le_afy
leaky125217722le_aky
leary85927382le_ary
leavy115715772le_avy
legal65715942lega_l
legally1138132legally
legals73412732legals
legate72917452legate
legato72810952legato
leggy105210242leg_gy
lunacy1136842lunacy
abbacy1536623abbacy
agency1237033agency
alegar739283alega_r
alegars838933alegars
angary10311323angary
beach124623893be_ach
beachy164011253be_achy
beady114719923be_ady
beaky146118023be_aky
beamy126218573be_amy
begall92610723begall
began86319573bega_n
begat86629723bega_t
begaze1838333begaze
beggary14316153beggary
belady12489933belady
belay105021523bela_y
bigamy1436333bigamy
bleach133611403ble_ach
bleary115112553ble_ary
cedary12419603cedary
curacy1339593curacy
deary95826843de_ary
decay114718483deca_y
deface123113863deface
degage92711383degage
degame102713183degame
degami10279003degami
degas75119163dega_s
delay94820633dela_y
denary105316863denary
deray95024183dera_y
detach12310413detach
digamy1335883digamy
each95530583_e_ach
easy76224493_e_asy
egad64215413_ega_d
egads74610923_egads
egal55119433_ega_l
eggy96611853_eg_gy
elegance1146363elegance
elegant8311503elegant
elegiac1045453elegiac_
elegiacs1144053elegiacs
elegy939303eleg__y
enact73525363_enact
epact94921533_epact
exact143516933_exact
fleecy14266483fle_ecy
gaby107123193__gaby
gamy105427533__gamy
gapy106320913__gapy
gay76856493__ga_y
gleamy12398113gle_amy
glegly1134873gleg_ly
heady125117263he_ady
heapy135914983he_apy
heavy144814183he_avy
hegari1039513hegari
ileac75814173ile_ac_
lac510155823l__ac_
lace66848473l__ace
lacey105820913l__acey
lack105837683l__ack
lacs66942483l__acs
lady86527153l__ady
lagan66520343laga_n
lagans75717783lagans
laky116725823l__aky
lay68865353l__a_y
lazy166423073l__azy
lea37660183le_a__
lead56038853le_a_d
leads66028493le_ads
leaf76441033le_a_f
leafs85721183le_afs
league758743league
leak86233713le_a_k
leaks95923913le_aks
leal46043273le_a_l
leally94012613leally
lealty92910603lealty
lean46345243le_a_n
leanly93811503leanly
leans55536253le_ans
leant56737783le_ant
leap66032683le_a_p
leaps75522933le_aps
leapt75027473le_apt
lear47045953le_a_r
learn55322663le_arn
lears55938733le_ars
leas45954183le_a_s
lease55230263le_ase
leash85519213le_ash
least56134883le_ast
leave84723723le_ave
lech96825443le__ch
ledgy105712013le_dgy
leech104913213le_ech
leery85919133le_ery
leeway1255883leeway
lefty115613563le_fty
leg46446113leg___
legacies1139043legacies
legality1237623legality
legated92513983legated
legatee82814633legatee
legates82917673legates
legator83011133legator
legatos82711183legatos
legend837693legend
leger65721503leg_er
legers74518313legers
leges64427283leg_es
legged95713083legged
leggin8268593leggin
legibly1344623legibly
legion75712983legion
legist71315253legist
legit61323503leg_it
legits71313003legits
legman949653legman
legmen939343legmen
legong836963legong
legs56133693leg__s
legume936913legume
leman75622603lema_n
lemans85316393lemans
lemony11419553lemony
lengthy1452733lengthy
lenity9612713lenity
letch105215803le_tch
leva77020713leva__
levant9314493levant
levity1277903levity
levy106418503le__vy
lewdly1334393lewdly
lexica1536103lexica
ley66246813le___y
lezzy16608083le_zzy
ligan67920283liga_n
ligand85011293ligand
ligans76817733ligans
ligase7259913ligase
ligate72519243ligate
lilac7311073lilac_
lilacs837483lilacs
linac7315413linac_
linacs8310813linacs
litany939053litany
literacy1346803literacy
loach105116363l_oach
loamy105913343l_oamy
logan68123283loga_n
logans76319063logans
loggy105714193log_gy
logic88217833logic_
logics95711123logics
logily1039833logily
logway1335913logway
logy87025783log__y
mealy104422183me_aly
meany104620473me_any
meaty107021313me_aty
mediacy1536143mediacy
mega77620873mega__
megacity1645713megacity
megara9310093megara
megass9219443megass
menace103216943menace
mercy125916183me_rcy
negate72915573negate
oogamy1235633oogamy
pacy115328683__pacy
papacy1547493papacy
peace95026083pe_ace
peach125422493pe_ach
peachy164510843pe_achy
peaky145718153pe_aky
peaty105725693pe_aty
peavy135014843pe_avy
piracy1339473piracy
pleach134211243ple_ach
plenary1237543plenary
prelacy1437583prelacy
racy95825683__racy
reach105123883re_ach
react74634333re_act
ready94821503re_ady
redact9419043redact
reface113616353reface
regain74517763regain
regal65023793rega_l
regale74821453regale
regally1159873regally
regard85215773regard
regave104713383regave
regency1337363regency
regnancy1444773regnancy
relace83122153relace
relay84424673rela_y
repack142412163repack
repay104818453repa_y
rerack122513163rerack
resay85320543resa_y
retack122612823retack
seamy105921273se_amy
senary93716073senary
serac75925203serac_
seracs84418573seracs
sleazy18267393sle_azy
spacy125415623_spacy
sugary1039013sugary
teach105221123te_ach
teary85124053te_ary
tenace82715693tenace
tenancy1237503tenancy
testacy1235963testacy
tetany959843tetany
vagary1337333vagary
vealy115817773ve_aly
vegan95114153vega_n
vegans103910853vegans
weary115620613we_ary

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162437.25015547.0
3Display Results2432430.0803037.5
 (SQL Overall)1786912437.48623870.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.