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

183 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
lizards1742761(None) 
liards75212611li_ards
lizard16369231lizard_
vizards20377261vizards
wizards20326401wizards
blizzards2042012blizzards
gizzards18133262gizzards
hazards2037462hazards
izars145112932_izar_s
izzards16143962izzards
lards65331862l__ards
lazars153812392lazar_s
liard65418592li_ard_
liars54723162li_ar_s
lidars7310782lidar_s
ligands9438982ligands
mazards1937702mazards
ritards8439942ritards
sizars154812622sizar_s
visards11328152visards
vizard19458852vizard_
wizard19377712wizard_
alidads936293alida_ds
alizarin1745863alizarin
alizarins1845893alizarins
awards107113453_awards
bards87139643__bards
bayards13379683bayards
bazars174613113bazar_s
beards94116673_beards
bicarbs1336013bicarbs
birds85421333bi__rds
bizarre1844103bizarre
bizarres1953793bizarres
bizarro1843333bizarro
bizarros1942713bizarros
blinkards1642723blinkards
blizzard1942303blizzard_
blizzardy2351343blizzardy
boards94616933_boards
boyards13399323boyards
briards10398553briards
buzzards1943613buzzards
canards10311203canards
cards85137933__cards
chards125119733_chards
cigars9910723cigar_s
cowards1339613cowards
czardas1934673_czardas
czars164812913_czar_s
diehards1346213diehards
dinars75417563dinar_s
disarms1039043disarms
discards1238913discards
dotards937253dotards
echards1337963echards
fards96629843__fards
fiars86720833fi_ar_s
fiords10498623fi_ords
gazars164811553gazar_s
girds74816993gi__rds
gizzard17114203gizzard_
goliards1045133goli_ards
guards84611573_guards
guisards1043603guisards
hards96435653__hards
hazard1938403hazard_
hoards104912623_hoards
holards1148433holards
iliads7448673ilia_ds
inarms8410093_inarms
innards837153innards
inwards1138343inwards
izar136616013_izar__
izzard15135243izzard_
jihads1734483jiha_ds
kinaras1159123kinaras
lads56549133l__a_ds
laggards11307053laggards
lahars94013163lahar_s
lairds74711613l_airds
lands65426903l__ands
laniards967313laniards
lanyards1266393lanyards
lard56742003l__ard_
lardy96119273l__ardy
lares54852633l__ares
laris54737463l__aris
larks95227813l__arks
lars46956573l__ar_s
lauds65618483l__auds
lazar144113643lazar__
lazaret16411783lazaret
lazarets1744803lazarets
leads66028493l_ea_ds
learns65513743l_earns
lears55938733l_ear_s
leewards1244983leewards
leopards1144753leopards
leotards945303leotards
lianas63713383li_anas
lianes63819323li_anes
liangs74410593li_angs
liar47229683li_ar__
libers84721443liber_s
libras83711703li_bras
lidar6312723lidar__
lids56336463li___ds
liers55130403li_er_s
lifers95617843lifer_s
ligand85011293ligand_
ligans76817733liga_ns
ligases82310713ligases
ligates82318383ligates
ligers75022043liger_s
ligures8269893ligures
likers104620913liker_s
lilacs837483lila_cs
limans84816303lima_ns
limas75627633lima__s
linacs8310813lina_cs
linages8813173linages
liners65428853liner_s
lipases9209483lipases
lipids94310923li_pids
lipoids1038233lipoids
liquids1735823liquids
liras56021983li__ras
litas54923773lita__s
liters65429883liter_s
litres65220393li_tres
livers94927823liver_s
livres94311863li_vres
loads65323373l_oa_ds
lords64923503l__ords
lunars65012813lunar_s
lyard95113213l_yard_
mazard1838763mazard_
mazzards1943943mazzards
milords10117853milords
misadds1136303misadds
nards65928463__nards
nicads938333nica_ds
niggards1144123niggards
nizams1735413niza_ms
onwards1137173onwards
pards85634333__pards
petards104311153petards
picaras11311283picaras
picaros11310893picaros
placards1345813placards
regards94112563regards
retards85015003retards
rewards114813993rewards
ribalds10236673ribalds
ribands10208393ribands
ritard74812083ritard_
sards64736183__sards
shards104319173_shards
simars84916933simar_s
sitars65417593sitar_s
sizar145214993sizar__
sizers155215813sizer_s
swards105415133_swards
tabards10310383tabards
tiaras6314553ti_aras
towards1138783towards
tzars144914273_tzar_s
unitards945623unitards
upwards13135963upwards
vawards14457573vawards
viands1047813vi_ands
vicars11712263vicar_s
visard103910123visard_
vizarded2242753vizarded
vizirs18306713vizir_s
vizors18328903vizor_s
wards97734403__wards
wizardly2452573wizardly
wizardry2451603wizardry
yards95324613__yards
yirds96612513yi__rds
zarfs174713623__zarfs

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.390458182.1
2DLD Change Limit1340271837.03019065.0
3Display Results1831830.0632904.8
 (SQL Overall)1786911837.48323879.6
 
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.