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

163 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
visuals103685(None) 
visual938801visual_
casuals91410522casuals
dismals102010242dismals
fiscals1238002fiscals
miskals13369762miskals
missals93914422missals
rituals738352rituals
sisals63013572sis_als
usuals637782_usuals
vassals1057952vassals
vestals104612332vestals
vials85822382vi__als
victuals1344772victuals
vinals94716482vi_nals
visas84317652vis_a_s
vistas94513272vista_s
visualise1245612visualise
visualist1246772visualist
visually1465492visually
vitals94514302vi_tals
annuals7388193annuals
bisexuals1843203bisexuals
casual81112863casual_
causals91411183causals
citrals91111673citrals
devisals1245613devis_als
dials64925343di__als
diquats1745983diquats
disbars10310323disbars
dismal92412243dismal_
dismays13237433dismays
dispels10310503dispels
distal73615773distal_
distils83015803distils
disuses84015413disuses
dossals8379293dossals
duals65620083__duals
equals1538693_equals
fibulas12228563fibulas
finals94316163fi_nals
finials103210153finials
fiscal1139333fiscal_
fistulas1155403fistulas
gimbals12257823gimbals
gimmals12225823gimmals
gingals9109313gingals
ideals75012503_ideals
instals7611713instals
isbas71010403_isba_s
jingals1588073jingals
jouals1338923_jouals
kismats13257843kismats
ligulas8329173ligulas
linguals9317223linguals
listels74212433listels
manuals9311213manuals
mescals112911563mescals
miauls8178713miau_ls
miscall1139653miscall
miscalls1239003miscalls
misdeals1147223misdeals
misdials1137493misdials
miseats92815783miseats
mishaps1438723mishaps
miskal123710263miskal_
mislays12349243mislays
missal84314903missal_
missays124010253missays
missels94614813missels
mistrals101212623mistrals
misuses93216023misuses
mutuals937123mutuals
nasals63312463nas_als
nisus56014393nisu__s
ovisacs1263283ovis_acs
pascals11610013pascals
pibals103813083pi_bals
piculs103511753picu_ls
pineals93212843pineals
pipals104213643pi_pals
pistils93314303pistils
pistols93213983pistols
postals93716373postals
rascals959663rascals
reseals73917663reseals
revisals1136813revis_als
rials55026673ri__als
risus54216393risu__s
risuses73210923risuses
ritual6310623ritual_
rivals94213183ri_vals
riyals94111083ri_yals
sals46851673__s_als
sauls55128123__sauls
seals54839693__seals
sials54227243__sials
signals8359163signals
sisal54217733sis_al_
ticals83214713ti_cals
timbals11239533timbals
tincals93610643tincals
tissual745193tissual_
unseals73212573unseals
usual5310183_usual_
vandals113211663vandals
vasal85516293vas_al_
vassal979243vassal_
veals84926193v__eals
verbals121910743verbals
vessels1035933vessels
vestal94615573vestal_
vestas95916683vesta_s
vial76731093vi__al_
vicars11712263vi_cars
victual1246253victual_
vicunas1285613vicunas
vigas94817883vi_ga_s
vigias104110893vigia_s
vigils104210193vi_gils
villas96117263villa_s
vills86429323vi__lls
vinal85725813vi_nal_
vinas85126343vi_na_s
vincas113912453vinca_s
vineal94814743vineal_
vinyls12467003vi_nyls
violas93713523viola_s
viols86118103vi__ols
viral86419593vi_ral_
virgas1048883virga_s
virls85618603vi__rls
virtual1045913virtual_
virus85316843viru__s
viruses1039413viruses
visa76323873vis_a__
visaed104110503vis_aed
visage1049083vis_age
visages1138693visages
visard103910123vis_ard
visards11328153visards
viscous1238833viscous
viscus11428503vis_cus
vises84427773vis__es
visible1236923visible
visibly1535043visibly
visions10311023visions
visits9311423vis_its
visors92912223vis_ors
vista85416603vista__
vistaed1138023vistaed
vistaless1254573vistaless
visualised1444073visualised
visualises1345123visualises
visualists1344893visualists
visuality1545443visuality
visualize2175583visualize
visualizes2265343visualizes
vital84819673vi_tal_
vivas114815023vi_va_s
vizslas1943143vizsla_s
vocals113811583v_ocals
wiseass1035823wiseass

Search took 7 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.410435831.7
2DLD Change Limit1340271635.59323963.3
3Display Results1631630.0602716.7
 (SQL Overall)1786911636.06329472.4
 
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.