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

152 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
vizards2037726(None) 
lizards17427611lizards
visards11328151visards
vizard19458851vizard_
wizards20326401wizards
gizzards18133262gizzards
hazards2037462hazards
izars145112932_izar_s
izzards16143962izzards
liards75212612li_ards
lizard16369232lizard_
mazards1937702mazards
ritards8439942ritards
sizars154812622sizar_s
vawards14457572vawards
viands1047812vi_ands
vicars11712262vicar_s
visard103910122visard_
vizarded2242752vizarded
vizirs18306712vizir_s
vizors18328902vizor_s
wizard19377712wizard_
awards107113453_awards
bards87139643__bards
bayards13379683bayards
bazars174613113bazar_s
beards94116673_beards
bicarbs1336013bicarbs
birds85421343bi__rds
bizarre1844103bizarre
bizarres1953793bizarres
bizarro1843333bizarro
bizarros1942713bizarros
blizzards2042013blizzards
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
girds74817003gi__rds
gizzard17114203gizzard_
guards84611573_guards
guisards1043603guisards
hards96435653__hards
hazard1938403hazard_
hoards104912623_hoards
holards1148433holards
inarms8410093_inarms
innards837153innards
inwards1138343inwards
izar136616013_izar__
izzard15135243izzard_
jihads1734483jiha_ds
kinaras1159123kinaras
lards65331863__lards
lazars153812393lazar_s
liard65418593li_ard_
liars54723163li_ar_s
lidars7310783lidar_s
ligands9438983ligands
mazard1838763mazard_
mazzards1943943mazzards
milords10117853milords
misadds1136303misadds
nards65928463__nards
nicads938333nica_ds
niggards1144123niggards
nizams1735413niza_ms
onwards1137173onwards
pards85634333__pards
petards104311153petards
picaras11311283picaras
picaros11310893picaros
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
varas86028193v__aras
vars75742073v__ar_s
varus85921183v__arus
vaward13498723vaward_
velars93913723velar_s
vials85822383vi_a_ls
viand9511073vi_and_
vicar10513863vicar__
vicarly1536463vicarly
vids85627553vi___ds
viers85621953vi_er_s
vigas94817883viga__s
vigors102911483vigor_s
vinals94716483vina_ls
vinas85126343vina__s
vineyards1643223vineyards
vipers114914533viper_s
viragos1146713viragos
vires84529683vi__res
virls85618603vi__rls
viroids1137923viroids
virus85316843vi__rus
visaed104110503visaed_
visages1138693visages
visas84317653visa__s
visors92912223visor_s
vitals94514303vita_ls
vivaces1536413vivaces
vivaria1346983vivaria
vivaries1439263vivaries
vivary1536983vivar_y
vivas114815023viva__s
vivers124717363viver_s
viziers19336203viziers
vizir17359393vizir__
vizor173010093vizor__
vizored2034133vizored
vizslas1943143vizslas
wards97734403__wards
wizardly2452573wizardly
wizardry2451603wizardry
yards95324613__yards
yirds96612523yi__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.423422437.4
2DLD Change Limit1340271527.10618861.1
3Display Results1521520.0503040.0
 (SQL Overall)1786911527.57923577.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.