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

408 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
laurels74666(None) 
laurel649031laurel_
saurels749301saurels
aludels835292aludels
aures55137092_aure_s
aureus65314882_aureus
barrels94514362barrels
carrels95117302carrels
jurels133710582_jurels
labels84515682la_bels
labrets939362labrets
langrels9106172langrels
lapels83712042la_pels
larees65323112la_rees
lares54852632la_re_s
lauders84012892lauders
lauras63414332laur_as
laureled934542laureled
lurers64217492l_urers
lures56138532l_ure_s
parrels94713492parrels
saurel6511992saurel_
acres76327763_acre_s
agrees74915323_agrees
airers64922313_airers
allurers8286773allurers
allures72913113allure_s
aludel747853aludel_
angels74416173_angels
appels104312793_appels
apres75426403_apre_s
areas55935773_a_reas
ares45871023_a_re_s
ariels65119373_ariels
arils58732203_a_rils
arles56735743_a_rles
artels66216233_artels
aryls87015813_a_ryls
augers73818703_augers
aural54428963_aural_
auras55932563_aur_as
aurei54821863_aure_i
aureola747033_aureola
aureolas846853_aureolas
aureole738693_aureole
aureoles838283_aureoles
auris55331533_aur_is
aurous64119263_aurous
aurums849383_aurums
axels126313633_a_xels
azures15510183azure_s
babels105216723ba_bels
bagels95712313ba_gels
barbels114514433barbels
barely114716793ba_rely
bares75457133ba_re_s
barrel84517873barrel_
barrens94414323barrens
barres84427543barre_s
barrets94917103barrets
baubees11348713baubees
baubles113611863baubles
blares85021633bla_re_s
burets84321263_burets
burls74228853_bur_ls
cadres94017933cadre_s
camels105217083ca_mels
cancels114113313cancels
cannels93413363cannels
carcels114516063carcels
carers85133963ca_rers
cares77369183ca_re_s
caress85720263ca_ress
carets85330773ca_rets
carles85435083ca_rles
carls77037423ca_r_ls
carols85124983ca_rols
carpels115315463carpels
carrel84718633carrel_
carrell94610473carrell
carrells10359273carrells
cartels94618123cartels
carvels124914593carvels
caudles103912813caudles
caules85927253caule_s
cauls75727773cau__ls
causals91411183causals
causers94014793causers
causes88026473cause_s
causeys12387223causeys
churls115411073chur_ls
clarets94111103cla_rets
clauses93813323clause_s
cupels10310203_cupels
curers84923193_curers
cures75645433_cure_s
curets84922343_curets
curls74927103_cur_ls
damsels10126703damsels
darers75921873da_rers
dares66146703da_re_s
darnels83710433darnels
daubers104610423daubers
daubes94913703daube_s
duels65619233_du_els
dures65635923_dure_s
duress74712063_duress
eagres74014573eagre_s
earls56127513ea_r_ls
easels65914553ea_sels
enures63919713enure_s
fardels11389893fardels
farers95924053fa_rers
fares85852873fa_re_s
farfels13348213farfels
farles96025783fa_rles
farls85731113fa_r_ls
faucals12326563faucals
fauces114916153fauce_s
faucets12578443faucets
fauves125610423fauve_s
ferrels10248623ferrels
flannels1134843flannels
flares94521703fla_re_s
fuels87117353_fu_els
furls85322053_fur_ls
fusels94412453_fusels
gambrels1334213gambrels
gangrels1094973gangrels
garrets84413623garrets
gaugers94211713gaugers
gauges85915993gauge_s
gaurs66317993gaur__s
gauzes164710633gauze_s
gavels105911093ga_vels
glaires84010133glaire_s
glares75518863gla_re_s
graupels1133103graupels
gruels73910153gru_els
haeres94017033haere_s
hallels103310133hallels
hansels104011653hansels
harems115513823ha_rems
hares86255543ha_re_s
harls85634503ha_r_ls
hassels104311013hassels
hatreds11307813hatreds
haulers104012443haulers
hauls86123733hau__ls
hausens1077633hausens
haverels14325753haverels
hazels185710083ha_zels
housels105312133housels
hurls86522713_hur_ls
inures63318953inure_s
jarls126120963ja_r_ls
jurel124516333_jurel_
kauries113613193kauries
kauris103611533kaur_is
knurls10396243knur_ls
kugels1146073_kugels
laagers83411253laagers
label75019383la_bel_
labials9299873labials
laborers10208383laborers
labourers1144713labourers
labret8320223labre_t
labrums1175853labrums
lacers85225253la_cers
laces76141763la_ce_s
laches116528343lache_s
lackers134120543lackers
lackeys16458263lackeys
lacteals1095663lacteals
lacunes9159623lacune_s
ladders94115173ladders
ladens74516233la_dens
laders74927763la_ders
lades65141273la_de_s
ladies75124883ladie_s
ladlers84613573ladlers
ladles74619543ladle_s
ladrons83813193ladrons
lagers74826143la_gers
laggers94216243laggers
lagunes8148523lagune_s
lairdly1134913lairdly
lairds74711613lair_ds
laired75216813laire_d
lairs55425873lair__s
lakers105225153la_kers
lakes95737653la_ke_s
lalls55324133la__lls
lambers113817113lambers
lameds94812033la_meds
lamely114013223la_mely
lames75445543la_me_s
lampers113817333lampers
lampreys1542883lampreys
lancers93616643lancers
lances84824103lance_s
lancets93411163lancets
landers84026213landers
lanely93914483la_nely
lanes54946793la_ne_s
langrel8107033langrel_
lanners73618333lanners
lapel73716683la_pel_
lapfuls1234503lapfuls
lappers113717463lappers
lappets11329123lappets
lapsers93911053lapsers
lapses85217693lapse_s
larders83516943larders
lards65331863la_r_ds
laree56036293la_re_e
largely1136703largely
larges74824233la_rges
largess8408913largess
largos74815063la_rgos
laris54737463la_r_is
larkers113014513larkers
larks95227813la_r_ks
larrups934733larrups
lars46956573la_r__s
larums83610533la_rums
larvas9310233la_rvas
lasers64925703la_sers
lases54944763la_se_s
lashers104121833lashers
lashes94831003lashe_s
lasses64827593lasse_s
lasters75627693lasters
lateens74210553lateens
lately93413843la_tely
latens64620213la_tens
laterals8312753laterals
lathers104321883lathers
lathes95127493lathe_s
latkes104715873latke_s
latrias71913213latrias
lattens75014673lattens
lattes65324203latte_s
lauans65113533lau_ans
lauded83812153laude_d
lauder73815013laude_r
lauds65618483lau__ds
laughers1235923laughers
laughs10489023lau_ghs
launces9329003launces
launders9358743launders
laundress1042813laundress
laura54116203laur__a
laurae64011663laur_ae
laureate888023laureate
laureates987683laureates
laureling1035643laureling
laurelled1043613laurelled
laveers10329363laveers
lavers94526363la_vers
laves86039153la_ve_s
lawless1037033lawless
lawyers13377153lawyers
laxes125430093la_xe_s
laxness1436043laxness
layers93921183la_yers
lazarets1744803lazarets
lazes145129573la_ze_s
lazies154418783lazie_s
lemures938793lemure_s
leudes75314093leude_s
levels94113283l_evels
libels85112693l_ibels
ligures8269893ligure_s
lintels73311163lintels
listels74212433listels
litres65220393litre_s
livres94311863livre_s
lores55045403l_ore_s
losels64714583l_osels
loudens8368053loudens
louies64525103louie_s
loupes84918053loupe_s
loured74617403loure_d
lours55125293lour__s
louses66230283louse_s
louvers10359103louvers
louvres10356523louvre_s
lubes74727993l_ube_s
luces75528433l_uce_s
lucres84513303lucre_s
ludes65728853l_ude_s
lues45943553l_u_e_s
lugers74617023l_ugers
luges65928753l_uge_s
lulls54119653l_u_lls
lumens85013973l_umens
lunes55337773l_une_s
lunets66914763l_unets
lure45142463l_ure__
lured65427493l_ure_d
lurer54625313l_ure_r
lurex124816733l_ure_x
lurexes1436073l_urexes
lurkers113910083l_urkers
lurks95218743l_ur_ks
lutes55836663l_ute_s
luxes124921503l_uxe_s
lyres85019963l_yre_s
madres93718183madre_s
mandrels1137313mandrels
mangels103614493mangels
mantels94515043mantels
manurers1037593manurers
manures9313353manure_s
marcels113212373marcels
mares76457633ma_re_s
marls75535163ma_r_ls
marrers93414313marrers
marvels123810093marvels
matres84522233matre_s
maturely1344893maturely
maturers1037373maturers
matures9314303mature_s
maulers94213303maulers
mauls76524953mau__ls
maumets11369693maumets
mauves113811553mauve_s
morels84820013_morels
murals84016763_murals
mures75937223_mure_s
nacres85614453nacre_s
nares55544153na_re_s
naturals847903naturals
natures7311963nature_s
nauseas735993nauseas
navels95712693na_vels
nurls55519683_nur_ls
ousels64815273_ousels
ouzels15408703_ouzels
padres95016983padre_s
panels84716523pa_nels
parcels113712663parcels
pareos87023773pa_reos
parers85530743pa_rers
pares77164483pa_re_s
pareus85420743pa_reus
parles86334403pa_rles
parols84722613pa_rols
parrals94414573parrals
parrel84515983parrel_
parures9512693parure_s
passels93913023passels
pastels95215183pastels
patrols93513513patrols
paupers114311073paupers
pausers94113223pausers
pauses84621473pause_s
petrels9279373petrels
plurals936913plurals
pourers93513673pourers
purees84721683_purees
purely114013633_purely
purls74723353_pur_ls
quarrels1735083quarrels
rappels11448803rappels
rarely93513653ra_rely
rares55247443ra_re_s
rasures7312013rasure_s
ratels64518213ra_tels
ravels94717073ra_vels
rubels84112993_rubels
sabres85520863sabre_s
sacrals93311793sacrals
safrols1036863safrols
samiels939763samiels
sarees65329943sa_rees
saucers93712133saucers
sauces84919503sauce_s
saugers83914053saugers
sauls55128123sau__ls
sauries72821623sauries
sautes63924913saute_s
sorels63921163_sorels
sorrels7310723sorrels
staumrels1141663staumrels
surely93816463_surely
taels56822073ta__els
tanrecs934823tanrecs
tares57456563ta_re_s
tarres64723043tarre_s
tassels74510853tassels
taupes8212673taupe_s
tautens7317843tautens
thurls9418713thur_ls
tourers73512743tourers
ureas55826013__ureas
usurers766363usurers
vakeels14113733vakeels
wadmels1334303wadmels
wares88250583wa_re_s
warrens103810893warrens
wastrels1136203wastrels
wauls86120553wau__ls
wurzels1934083_wurzels
yarely122810303ya_rely
yaupers12337663yaupers
zaires1539703zaire_s

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274087.08018930.4
3Display Results4084080.1402914.3
 (SQL Overall)1786914087.62623431.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.