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

245 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
lured6542749(None) 
cured85932131cured
dured75025401dured
loured74617401loured
lubed85319891lubed
luged74019091luged
lure45142461lure_
lurer54625311lurer
lures56138531lures
lurex124816731lurex
lurid64618971lurid
lurked114511971lurked
luted64826141luted
mured85726701mured
acred87126352acred
aired66032922aired
allured8299172allured
aurei54821862aurei
aures55137092aures
bared85144482bared
blared95018242blared
blued84520322blu_ed
blumed114313642blumed
blurbed12337612blurbed
blurred10427802blurred
blurted10399782blurted
bored85034302bored
bred75130972_bred
burd75534262bur_d
buret77444012buret
buried94822372buried
burked135220882burked
burled94825382burled
burned95818962burned
burped116215502burped
burred95820722burred
bused85624492bused
cared86050092cared
cered85227442cered
cloured103111542cloured
clued84917682clu_ed
cored85044222cored
cred76530882_cred
cubed105519702cubed
cued76329562cu_ed
curbed114615872curbed
curd77634982cur_d
curded104217162curded
cure66149122cure_
curer75030752curer
cures75645432cures
curet75447642curet
curled95021652curled
curred94319262curred
cursed94321252cursed
curved124815222curved
dared75935012dared
duded84417132duded
duked115218462duked
duped95118322duped
dure56341812dure_
dures65635922dures
durned84113172durned
eared65139502eared
eluded84612772eluded
eluted74915262eluted
enured73315332enured
erred65915672erred
fared95842342fared
fired94829742fired
flared105317602flared
floured11289872floured
flued95021252flu_ed
fluked145112092fluked
flumed124915262flumed
fluted104917162fluted
fluxed17509672fluxed
fumed116118822fumed
furled104717052furled
furred104514432furred
fused94820442fused
fuzed185415252fuzed
glared84715202glared
glued75118362glu_ed
gored75227082gored
gurged95513362gurged
guyed1049892guyed
gyred105114092gyred
hared95742182hared
hired95226262hired
hued86925852hu_ed
hurled104617452hurled
inured73114812inured
ired55131872_ired
juked175714072juked
jurel124516332jurel
juried144212442juried
kluged12427232kluged
laced87132642laced
laded74232612laded
laired75216812laired
laked105731122laked
lamed85235292lamed
lard56742002lar_d
larded84319092larded
laree56036302laree
lares54852632lares
larked114519472larked
lased65132342lased
lated65240672lated
lauded83812152lauded
laurel649032laurel
laved95028592laved
lawed96028322lawed
layed95127382layed
lazed154925842lazed
led46254552l__ed
leered73816222leered
lied55838092l_ied
liked104523812liked
limed85426802limed
lined64934642lined
lire47845292lire_
lived95523722lived
lobed86022132lobed
looed64626132looed
loped85128332loped
lord55032082lor_d
lorded84916732lorded
lore45850352lore_
lores55045402lores
louped95316382louped
loused74822912loused
louted74920692louted
louvred11354662louvred
loved95021362loved
lowed95233902lowed
loxed135017052loxed
lube64731562lube_
lubes74727992lubes
luce65132572luce_
luces75528432luces
lucid84314572lucid
lucked135118022lucked
lucre76415522lucre_
lucres84513302lucres
lude55331642lude_
ludes65728852ludes
lues45943552lu_es
luffed133810822luffed
luge55531642luge_
luger65322082luger
luges65928752luges
lugged94417062lugged
lulled74516442lulled
lumen75220902lumen
lumped114216962lumped
lune47140492lune_
lunes55337772lunes
lunet56835422lunet
lunged85418272lunged
lunted74517522lunted
lurch104814632lurch
lurched13358032lurched
lurers64217492lurers
lurk86624162lur_k
lurker103613292lurker
lurks95218742lurks
lushed104218722lushed
lusted74319442lusted
lustred8359052lustred
lute46341012lute_
lutea54819072lutea
lutes55836662lutes
luxe115222692luxe_
luxes124921502luxes
lyre75623792lyre_
lyres85019962lyres
lysed95011562lysed
mired85729222mired
muled85824432muled
mure65941332mure_
mures75937222mures
murex145517172murex
murid84520582murid
mused85524582mused
muted85023382muted
nuked104014182nuked
nurd56224342nur_d
nurled74016232nurled
nursed74514672nursed
oared65030652oared
outed65429062outed
pared86946762pared
plumed114412882plumed
pored85234512pored
poured95116742poured
puked124716222puked
puled84926522puled
pure65543332pure_
puree74632842puree
pureed95017812pureed
purer75127902purer
purged104918262purged
purled94520752purled
purred94218072purred
pursed95220882pursed
quired163711952quired
rared65738322rared
red46755802__red
rued55729792ru_ed
ruled65822522ruled
sered65737292sered
shred98125612shred
sired66134282sired
slued64220512slu_ed
slurped10368752slurped
slurred8359192slurred
sored66141782sored
soured74921862soured
sued56537932su_ed
surd56433812sur_d
sure45447412sure_
surer54833102surer
surfed103814462surfed
surged84118882surged
tared69340052tared
tired65228902tired
toured74216152toured
trued65117692trued
tubed85818042tubed
tuned64622312tuned
turd56027622tur_d
turfed103110962turfed
turned73914472turned
tyred95816432tyred
urd46427052_ur_d
urea46528062_urea
uredo65112992_uredo
urged75316032_urged
urped84615282_urped
used55722822_used
velured1136682velured
wared96339872wared
wired95327642wired

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.313570897.8
2DLD Change Limit538002451.53035163.4
3Display Results2452450.0633888.9
 (SQL Overall)1786912451.90693751.8
 
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.