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

211 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
vizard1945885(None) 
lizard16369231lizard
visard103910121visard
vizards20377261vizards
wizard19377711wizard
gizzard17114202gizzard
hazard1938402hazard
izar136616012_izar_
izars145112932_izars
izzard15135242izzard
liard65418592li_ard
lizards17427612lizards
mazard1838762mazard
ritard74812082ritard
sizar145214992sizar_
sizars154812622sizars
vaward13498722vaward
viand9511072vi_and
vicar10513862vicar_
vicars11712262vicars
visaed104110502visaed
visards11328152visards
vivary1536982vivary
vizarded2242752vizarded
vizir17359392vizir_
vizirs18306712vizirs
vizor173010092vizor_
vizored2034132vizored
vizors18328902vizors
wizards20326402wizards
aboard9312613aboard
afeard1058263afeard
airward1148133airward
aviary12338413avi_ary
award97118043_award
bard75648863__bard
bayard124411663bayard
bazar163816003bazar_
bazars174613113bazars
beard86024963_beard
bicarb1238543bicarb
binary11312223binary
bird76128323bi__rd
bizarre1844103bizarre
bizarro1843333bizarro
blizzard1942303blizzard
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
guard74415543_guard
guisard954203guisard
hard85443503__hard
hazards2037463hazards
heard95222753_heard
hilar85418143hilar_
hoard94918313_hoard
holard10410573holard
inarm7314423_inarm
inward10310333inward
izzards16143963izzards
jihad1635913jiha_d
kinara10310373kinara
lard56742003__lard
lazar144113643lazar_
lazars153812393lazars
liar47229683li_ar_
liards75212613li_ards
liars54723163li_ars
lidar6312723lidar_
lidars7310783lidars
ligand85011293ligand
lyard95113213_lyard
mazards1937703mazards
mazzard1844463mazzard
milord999573milord
misadd1037163misadd
nard56634453__nard
nicad8312613nica_d
niggard1044943niggard
nizam16310253niza_m
nizams1735413nizams
onward1039053onward
ovipara1242543ovipara
pard76441323__pard
petard95013803petard
picara10311903picara
picaro10311323picaro
pilar75221503pilar_
pizazz1554223pizazz
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
vagary1337333vagary
vanward1456943vanward
var66148333v__ar_
vara75530883v__ara
vars75742073v__ars
vary105226063v__ary
vawards14457573vawards
velar85817633velar_
velars93913723velars
via65636243vi_a__
vial76731093vi_a_l
vialed105112593vialed
vials85822383vi_als
viands1047813vi_ands
vicarly1536463vicarly
viced115118183vi_ced
vid77241813vi___d
vied86328633vi__ed
vier75428153vi_er_
viers85621953vi_ers
viewed1345993viewed
viga85622963viga__
vigas94817883viga_s
vigor92612423vigor_
vigors102911483vigors
viler86324163viler_
vina76331803vina__
vinal85725813vina_l
vinals94716483vinals
vinas85126343vina_s
vined95626153vi_ned
vinery124912603vinery
vineyard1543983vineyard
viper105017303viper_
vipers114914533vipers
virago1046643virago
viral86419593vira_l
virid94116043vi_rid
virl76224473vi__rl
viroid10411523viroid
visa76323873visa__
visage1049083visage
visaged1235683visaged
visas84317653visa_s
viscid1237473viscid
vised95518763vi_sed
viseed105310983viseed
visor82512833visor_
visored1138143visored
visors92912223visors
vistaed1138023vistaed
vita75828523vita__
vitae84217633vita_e
vital84819673vita_l
vitals94514303vitals
viva106119093viva__
vivace1436553vivace
vivaria1346983vivaria
vivas114815023viva_s
vivers124717363vivers
vivid125112313vi_vid
vizier184311023vizier
viziers19336203viziers
vizsla1833703vizsla
volar86917413volar_
votary12248333votary
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 Limit1127162114.56324702.2
3Display Results2112110.0762776.3
 (SQL Overall)1786912115.01235652.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.