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

187 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
vesical1215981(None) 
vesica11157911vesica_
vesicae12177701vesicae
epical10413392_epical
gestical1138992gestical
helical12311152helical
lexical1637362lexical
medical12312512medical
mescal104113492mes_cal
mesial84818082mesi_al
metical11315362metical
musical1139552musical
vatical1239982vatical
veinal93812962ve_inal
venial94218282veni_al
vertical13410432vertical
vesicant1347502vesicant
vesicate131210052vesicate
vesicle12217922vesicle
vesicula1345222vesicula
vestal94615572ves_tal
vestral104111012vestral
aecial84817313aeci_al
aerial64625713aeri_al
aestival1145483aestival
apical10913903_apical
apsidal1046703apsidal
basinal9310033basinal
bestial9311643bestial
cecal94619113ce__cal
cercal10314123ce_rcal
cervical1546853cervical
chemical1748393chemical
clerical1248233clerical
comical13312223comical
conical11316203conical
cosmical1448013cosmical
cubical1338463cubical
cynical1437873cynical
decal85523233de__cal
decimal1238083decimal
deifical1445543deifical
deistical1246673deistical
denial74720513deni_al
despisal1144673despisal
devisal1136913devisal
domical1239373domical
edictal1046993_edictal
erica7316543_erica_
ericas8315463_ericas
escar74011993_es_car
espial839543_espial
estival1036323_estival
estral64716513_estral
ethical1238443ethical
fascial1258303fascial
fecal105119213fe__cal
fecial114714623feci_al
ferial94621253feri_al
festal94213563fes_tal
festival1444713festival
fetial95716193feti_al
finical1239693finical
fiscal1139333fis_cal
geminal10109913geminal
genial74917613geni_al
genital849793genital
geoidal936713geoidal
hectical1547933hectical
heliacal1344723heliacal
heroical13410023heroical
irenical1048553irenical
laical8312323_laical
lexica1536103lexica_
logical1038513logical
lyrical1236493lyrical
magical1239783magical
medial93819863medi_al
medicals1349363medicals
menial84223033meni_al
meniscal1246203meniscal
mescals112911563mes_cals
mesian84315503mesi_an
mesic93617863mesic__
mesically16310093mesically
meticals12310763meticals
metrical12311593metrical
mezcal19367853me_zcal
mimical1339233mimical
musicale1247343musicale
musicals1247093musicals
mystical1546933mystical
nasial6413283nasi_al
nodical1049863nodical
oedipal1045173oedipal
optical1149863optical
pascal10812373pas_cal
pedicab1446693pedicab
pedicel1237813pedicel
pedocal1237893pedocal
pelican1139433pelican
pemican1348163pemican
penial84120893peni_al
penicil1138833penicil
physical1845703physical
pical95524373__pical
plical10411683_plical
poetical12311533poetical
radical103312793radical
rascal8511123ras_cal
recital9412163recital
redial74923113redi_al
reginal84814293reginal
rescale93215473res_cale
reseal64819643res_eal
residual9245443residual
retial64724993reti_al
retinal75318353retinal
revisal1038263revisal
revival1337033revival
rustical1048393rustical
scenical1247133scenical
seismal937303seismal
seismical1344643seismical
seminal91213413seminal
septical1259363septical
serial64625863seri_al
sial45938833__si_al
sisal54217733__sisal
sterical10311253sterical
stoical9310283stoical
telial65815363teli_al
thetical1349123thetical
tical76021493__tical
topical1139953topical
toxical1637643toxical
typical1436343typical
vaginal11288403vaginal
vasal85516293vas__al
vassal979243vas_sal
veal76936813ve___al
vegetal1156303vegetal
vehicle15175253vehicle
veil75523593ve_i__l
venal85523213ve__nal
venatical1446793venatical
ventral103612173ventral
verbal112513663ve_rbal
veridical1545983veridical
veritas103012753veritas
vernal93514213ve_rnal
versal93013753ve_rsal
versicle1366583versicle
versional1245863versional
verticals1457243verticals
verticil1366913verticil
vesicants1444753vesicants
vesicated15117653vesicated
vesicates14119033vesicates
vesicles13127073vesicles
vesiculae1445203vesiculae
vesicular1445473vesicular
vesperal1344883vesperal
vessel937953ves_sel
vesta86618303ves_ta_
vestals104612333ves_tals
vestas95916683ves_tas
vestigial1343773vestigial
vestural1156473vestural
vexil1538963vexi__l
vexilla1744663vexilla
vial76731093v__i_al
viatical1347063viatical
vicar10513863v__icar
vicinal12268543vicinal
vigesimal1551943vigesimal
viminal12288823viminal
vinal85725813v__inal
viral86419593v__iral
visional1146663visional
visual938803vis_ual
vital84819673v__ital
vocal104715643v__ocal
vomica1336383vomica_
vomicae1445303vomicae
vortical1348863vortical
xenial133414903xeni_al

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.390458182.1
2DLD Change Limit1340271877.19018640.8
3Display Results1871870.0632968.3
 (SQL Overall)1786911877.64323379.7
 
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.