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

265 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
lizard1636923(None) 
liard65418591li_ard
lizards17427611lizards
vizard19458851vizard
wizard19377711wizard
blizzard1942302blizzard
gizzard17114202gizzard
hazard1938402hazard
izar136616012_izar_
izars145112932_izars
izzard15135242izzard
lard56742002l__ard
lazar144113642lazar_
lazars153812392lazars
liar47229682li_ar_
liards75212612li_ards
liars54723162li_ars
lidar6312722lidar_
lidars7310782lidars
ligand85011292ligand
lyard95113212l_yard
mazard1838762mazard
ritard74812082ritard
sizar145214992sizar_
sizars154812622sizars
visard103910122visard
vizards20377262vizards
wizards20326402wizards
aboard9312613aboard
afeard1058263afeard
airward1148133airward
alidad838883alida_d
alizarin1745863alizarin
award97118043_award
bard75648863__bard
bayard124411663bayard
bazar163816003bazar_
bazars174613113bazars
beard86024963_beard
bicarb1238543bicarb
binary11312223binary
bird76128323bi__rd
bizarre1844103bizarre
bizarro1843333bizarro
blinkard1543043blinkard
blizzards2042013blizzards
blizzardy2351343blizzardy
board85523003_board
boyard125411283boyard
briard94311293briard
buzzard1844273buzzard
canard9314763canard
card710245873__card
chard116124743_chard
cigar8911803cigar_
cigars9910723cigars
coward12411673coward
czar156013133_czar_
czars164812913_czars
diary95016973di_ary
diehard1237053diehard
dinar66319893dinar_
dinars75417563dinars
disarm9310473disarm
discard11310213discard
dotard839053dotard
echard1249223echard
fard85639063__fard
fiar76427333fi_ar_
fiars86720833fi_ars
filar84819293filar_
fiord94313343fi_ord
fizzed18369443fizzed
gazar154612983gazar_
gazars164811553gazars
gird65424993gi__rd
gizzards18133263gizzards
goliard936073goli_ard
guard74415543_guard
guisard954203guisard
hard85443503__hard
hazards2037463hazards
heard95222753_heard
hilar85418143hilar_
hoard94918313_hoard
holard10410573holard
iliad64613463ilia_d
inarm7314423_inarm
inward10310333inward
izzards16143963izzards
jihad1635913jiha_d
kinara10310373kinara
laari54415713l_aari
labara83712893labara
lad48165703l__a_d
laggard10347623laggard
lahar83114263lahar_
lahars94013163lahars
laid56439143l__aid
laird65417793l_aird
land56337313l__and
laniard868523laniard
lanyard1167293lanyard
lar37967533l__ar_
lards65331863l__ards
lardy96119273l__ardy
lari45839153l__ari
lark85733863l__ark
lars46956573l__ars
laud56527723l__aud
lazaret16411783lazaret
lazed154925843laz_ed
lazied164610653lazied
lead56038853l_ea_d
lear47045953l_ear_
learn55322663l_earn
lears55938733l_ears
leary85927383l_eary
leeward1135783leeward
leopard1045293leopard
leotard846193leotard
liana53915893li_ana
liane54720663li_ane
liang64914413li_ang
liber74723623liber_
libers84721443libers
libra74712423li_bra
librae84310173librae
library1245323library
libras83711703libras
libri74610113li_bri
licked134621563licked
lid47453523li___d
lidded93410243lidded
lied55838093li__ed
lier45942463li_er_
liers55130403li_ers
lifer85822153lifer_
lifers95617843lifers
lifted104413523lifted
ligan67920283liga_n
ligands9438983ligands
ligans76817733ligans
ligase7259913ligase
ligate72519253ligate
ligated92414143ligated
liger65024473liger_
ligers75022043ligers
ligure7279473ligure
liked104523813li_ked
liker95627063liker_
likers104620913likers
lilac7311073lila_c
lilacs837483lilacs
lilied73913213lilied
lilted73715373lilted
lima65734133lima__
liman75921603lima_n
limans84816303limans
limas75627633lima_s
limbed114513183limbed
limed85426803li_med
limned94811473limned
limped114817123limped
limpid11389753limpid
linac7315413lina_c
linacs8310813linacs
linage7713403linage
linear65113343linear_
lined64934643li_ned
liner55938923liner_
liners65428853liners
linked114518213linked
linted74021823linted
lipa68425923lipa__
lipase8239103lipase
lipid85916173li_pid
lipoid9411043lipoid
lipped114419543lipped
liquid1637143liquid
lira46928683li__ra
liras56021983lira_s
lire47845293li__re
liri45128253li__ri
lisped94113423lisped
listed74322833listed
litai55216363lita_i
litany939053litany
litas54923773lita_s
liter54736343liter_
liters65429883liters
litre55421463li_tre
lived95523723li_ved
liver85132963liver_
livered113111633livered
livers94927823livers
livery124910903livery
livid96714423li_vid
livre85613253li_vre
load56730603l_oa_d
lobar7313013lobar_
lord55032083l__ord
lunar57017313lunar_
lunars65012813lunars
lyart85121883l_yart
mazards1937703mazards
mazzard1844463mazzard
milord999573milord
misadd1037163misadd
nard56634453__nard
nicad8312613nica_d
niggard1044943niggard
nizam16310253niza_m
nizams1735413nizams
olivary1345163olivary
onward1039053onward
pard76441323__pard
petard95013803petard
picara10311903picara
picaro10311323picaro
pilar75221503pilar_
pizazz1554223pizazz
placard1236783placard
regard85215773regard
retard75018933retard
reward106017643reward
ribald9209293ribald
riband9239623riband
ritards8439943ritards
sard55344243__sard
shard96125963_shard
simar74920813simar_
simars84916933simars
sitar54820543sitar_
sitars65417593sitars
sized155519243siz_ed
sizer145521813sizer_
sizers155215813sizers
sward94221463_sward
tabard9313333tabard
tiara5315913ti_ara
toward10311063toward
tzar136315373_tzar_
tzars144914273_tzars
unitard838003unitard
upward12147163upward
vaward13498723vaward
viand9511073vi_and
vicar10513863vicar_
vicars11712263vicars
visaed104110503visaed
visards11328153visards
vivary1536983vivary
vizarded2242753vizarded
vizir17359393vizir_
vizirs18306713vizirs
vizor173010093vizor_
vizored2034133vizored
vizors18328903vizors
ward86542253__ward
wizardly2452573wizardly
wizardry2451603wizardry
yard85633253__yard
yird87018983yi__rd
zarf166929123__zarf

Search took 6 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.373479064.3
2DLD Change Limit1127162655.37620966.5
3Display Results2652650.0932849.5
 (SQL Overall)1786912655.84230587.3
 
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.