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

243 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
visual93880(None) 
visuals1036851visuals
casual81112862casual
dismal92412242dismal
distal73615762distal
fiscal1139332fiscal
miskal123710262miskal
missal84314902missal
ritual6310612ritual
sisal54217732sis_al
tissual745192tissual
usual5310182_usual
vasal85516292vas_al
vassal979242vassal
vestal94615572vestal
vial76731092vi__al
victual1246252victual
vinal85725812vi_nal
vineal94814742vineal
viral86419592vi_ral
virtual1045912virtual
visa76323872vis_a_
visas84317652vis_as
vista85416602vista_
vistas94513272vistas
visually1465492visually
vital84819672vi_tal
actual8311023actual
annual64710703annual
basal75722283bas_al
biaxal1536093biaxal
binal75323823bi_nal
bisexual1743803bisexual
byssal1134993byssal
casuals91410523casuals
causal81413203causal
censual937663censual
citral81113883citral
costal85419513costal
crissal937413crissal
cuspal1037883cuspal
devisal1136913devis_al
dial55935063di__al
diquat1639763diquat
disbar938513disbar
dismals102010243dismals
dismay12229473dismay
dispel9310323dispel
distil73616433distil
disuse74012833disuse
dividual1344053dividual
dossal75510303dossal
dual55928173__dual
equal1449823_equal
festal94213563festal
fibula11258053fibula
figural1145233figural
filial93013253filial
final83922033fi_nal
finial92814183finial
fiscals1238003fiscals
fissural1143703fissural
fistula1045503fistula
gimbal11228803gimbal
gimmal11247513gimmal
gingal81010143gingal
hiatal9310193hiatal
hiemal11339493hiemal
ideal65716393_ideal
ileal56118083_ileal
ilial55317833_ilial
instal6712183instal
isba61310873_isba_
isbas71010393_isbas
jingal1498583jingal
joual12311653_joual
kismat123011673kismat
lienal63912783lienal
ligula7359673ligula
lineal65616023lineal
lingual8379063lingual
listel64214733listel
manual8313463manual
mescal104113483mescal
mesial84818083mesial
miasmal1176743miasmal
miaul71612123miau_l
miscall1139643miscall
misdeal1037663misdeal
misdial1039643misdial
miseat82925703miseat
mishap1338863mishap
miskals13369763miskals
mislay113510683mislay
missals93914423missals
missay114112143missay
missel85216523missel
mistral91013633mistral
misuse83213643misuse
mitral81314323mitral
mutual838503mutual
nasal56217593nas_al
nasial6413283nasial
nidal65217103ni_dal
nisus56014393nisu_s
nival84915773ni_val
nonvisual1243993nonvisual
oviducal1441743oviducal
ovisac1153953ovis_ac
pascal10812373pascal
pausal81511963pausal
pial65636703pi__al
pibal95217323pi_bal
pical95524373pi_cal
picul95015363picu_l
pineal84817683pineal
pinnal84814273pinnal
pipal95118353pi_pal
pistil83915073pistil
pistol83313333pistol
postal84317533postal
rascal8511123rascal
reseal64819643reseal
revisal1038263revis_al
rial45938093ri__al
rictal83113173rictal
risus54216393risu_s
rituals738353rituals
rival85216503ri_val
riyal84413433ri_yal
sal36462883__s_al
saul45836523__saul
seal45654373__seal
seismal937303seismal
sensual738053sensual
sexual1338413sexual
sial45938833__sial
signal73711483signal
sisals63013573sis_als
subvisual1452593subvisual
sural55931263__sural
tibial849833tibial
tical76021493ti_cal
tidal64516443ti_dal
timbal102510743timbal
tincal83913353tincal
tineal66216153tineal
tussal6288323tussal
ungual738183ungual
unseal63315473unseal
unusual743943unusual
usuals637783_usuals
vacua10510463vacua_
vagal94613633v_agal
valval12398863valval
vandal103713833vandal
vasa76522973vas_a_
vascula1245853vascula
vassals1057953vassals
veal76936813v__eal
veinal93812963veinal
venal85523213v_enal
venial94218283venial
verbal112513663verbal
vernal93514213vernal
versal93013753versal
vesical12159813vesical
vessel937953vessel
vesta86618303vesta_
vestals104612333vestals
vestas95916683vestas
vestral104111013vestral
vestural1156473vestural
via65636243vi__a_
vials85822383vi__als
vicar10513863vi_car
vicinal12268543vicinal
victuals1344773victuals
vicuna11115903vicuna
vicunas1285613vicunas
viga85622963vi_ga_
vigas94817883vi_gas
vigia94813273vigia_
vigias104110893vigias
vigil94313003vi_gil
vill75235073vi__ll
villa85321233villa_
villae95615383villae
villas96117263villas
viminal12288823viminal
vina76331803vi_na_
vinals94716483vi_nals
vinas85126343vi_nas
vinca105315163vinca_
vincas113912453vincas
vincula1246393vincula
vinyl115311623vi_nyl
viol76523593vi__ol
viola85915543viola_
violas93713523violas
virga9310253virga_
virgas1048883virgas
virl76224473vi__rl
virus85316843viru_s
vis66747613vis___
visaed104110503visaed
visage1049083visage
visard103910123visard
visceral1344673visceral
viscid1237473viscid
viscus11428503viscus
vise75632673vis__e
vised95518763vis_ed
viseed105310983viseed
vises84427773vis_es
visible1236923visible
visibly1535043visibly
vising103915873vising
vision9311313vision
visional1146663visional
visit8320963vis_it
visits9311423visits
visive1257873visive
visor82512833vis_or
visors92912223visors
vistaed1138013vistaed
visualise1245603visualise
visualist1246773visualist
visuality1545443visuality
visualize2175583visualize
vita75828523vi_ta_
vitae84217633vi_tae
vitals94514303vi_tals
vitta85015173vitta_
vittae93910993vittae
viva106119093vi_va_
vivas114815023vi_vas
vizsla1833703vizsla_
vizslas1943143vizslas
vocal104715643v_ocal
vulval12417663vulval
wisha114910853wisha_
withal1238933withal

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.1701051123.5
2DLD Change Limit1127162435.19021717.9
3Display Results2432430.0932612.9
 (SQL Overall)1786912435.45332769.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.