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

186 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
visards1132815(None) 
visard103910121visard_
vizards20377261vizards
disarms1039042disarms
discards1238912discards
guisards1043602guisards
liards75212612li_ards
lizards17427612lizards
misadds1136302misadds
ritards8439942ritards
sards64736182__sards
vawards14457572vawards
viands1047812vi_ands
vicars11712262vicar_s
visaed104110502visaed_
visages1138692visages
visas84317652visa__s
visors92912222visor_s
vizard19458852vizard_
wizards20326402wizards
absurds1035003absurds
awards107113453_awards
bards87139643__bards
bastards113310313bastards
bayards13379683bayards
beards94116673_beards
bicarbs1336013bicarbs
birds85421333bi__rds
bistres94017213bistres
bistros92810983bistros
boards94616933_boards
boyards13399323boyards
briards10398553briards
bustards11308513bustards
canards10311203canards
cards85137933__cards
chards125119733_chards
cigars9910723cigar_s
costards113510793costards
cowards1339613cowards
custards11338393custards
dastards10278083dastards
desands94810163desands
diehards1346213diehards
dinars75417563dinar_s
disarm9310473disar_m
disbands1237353disbands
disbars10310323disbar_s
disbuds11125243disbuds
discard11310213discard_
discords1238593discords
disparts11109953disparts
dotards937253dotards
echards1337963echards
fards96629843__fards
fiars86720833fi_ar_s
fiords10498623fi_ords
girds74816993gi__rds
gisarme1044173gisarme
gisarmes1144433gisarmes
gizzards18133263gizzards
guards84611573_guards
guisard954203guisard_
hards96435653__hards
hazards2037463hazards
hoards104912623_hoards
holards1148433holards
inarms8410093_inarms
innards837153innards
inwards1138343inwards
islands837323_islands
izars145112933_izar_s
izzards16143963izzards
jihads1734483jiha_ds
kinaras1159123kinaras
lards65331863__lards
liard65418593li_ard_
liars54723163li_ar_s
lidars7310783lidar_s
ligands9438983ligands
lizard16369233lizard_
mansards1148013mansards
mazards1937703mazards
milords10117853milords
misacts1139353misacts
misadd1037163misa_dd
misaims11310113misaims
misawards1563793misawards
misers85025703miser_s
mismarks1645893mismarks
misparts12108173misparts
miswords1446603miswords
mustards11297883mustards
nards65928463__nards
nicads938333nica_ds
niggards1144123niggards
onwards1137173onwards
ovisacs1263283ovisa_cs
pards85634333__pards
petards104311153petards
picaras11311283picaras
picaros11310893picaros
regards94112563regards
retards85015003retards
rewards114813993rewards
ribalds10236673ribalds
ribands10208393ribands
risers64624783riser_s
ristras7311563ristras
ritard74812083ritard_
saids65328853__saids
sands65228583__sands
sard55344243__sard_
saris54544953__saris
sarks96632463__sarks
sarods74918573__sarods
saros55238063__saros
shards104319173_shards
simars84916933simar_s
sisals63013573sisa_ls
sitars65417593sitar_s
sizars154812623sizar_s
sords64527803__sords
surds65624663__surds
swards105415133_swards
tabards10310383tabards
tiaras6314553ti_aras
tisanes7311853tisanes
towards1138783towards
tsars56717113_tsar_s
unitards945623unitards
upwards13135963upwards
varas86028193v__aras
vars75742073v__ar_s
varus85921183v__arus
vaward13498723vaward_
velars93913723velar_s
vespids1334613vespids
vials85822383vi_a_ls
viand9511073vi_and_
vicar10513863vicar__
vicarly1536463vicarly
vids85627543vi___ds
viers85621953vi_er_s
vigas94817883viga__s
vigors102911483vigor_s
vinals94716483vina_ls
vinas85126343vina__s
vineyards1643223vineyards
vipers114914533viper_s
viragos1146713viragos
vires84529683vi__res
virls85618603vi__rls
viroids1137923viroids
virus85316843vi__rus
visa76323873visa___
visage1049083visa_ge
visaged1235683visaged
visaing11279333visaing
viscid1237473viscid_
viscous1238833viscous
viscus11428503vis_cus
vised95518763vis_ed_
viseed105310983viseed_
vises84427773vis__es
visions10311023visions
visits9311423vis_its
visor82512833visor__
visored1138143visored
vistaed1138023vistaed_
vistas94513273vis_tas
visuals1036853visuals
vitals94514303vita_ls
vivaces1536413vivaces
vivaria1346983vivaria
vivaries1439263vivaries
vivary1536983vivar_y
vivas114815023viva__s
vivers124717363viver_s
vizarded2242753vizarded
vizirs18306713vizir_s
vizors18328903vizor_s
wards97734403__wards
wizard19377713wizard_
yards95324613__yards
yirds96612513yi__rds

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.873204686.1
2DLD Change Limit1340271866.87619492.0
3Display Results1861860.0632952.4
 (SQL Overall)1786911867.81222873.9
 
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.