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

127 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
vertical1341043(None) 
verticals1457241verticals
verticil1366911verticil
vortical1348861vortical
cervical1546852cervical
cortical12412212cortical
erotical101911982_erotical
gestical1138982gestical
hectical1547932hectical
heretical1448632heretical
heroical13410022heroical
metical11315362me_tical
metrical12311592metrical
septical1259362septical
tertial7313862terti_al
vatical1239982v_atical
venatical1446792venatical
veridical1545982veridical
vertically18410932vertically
vertices13612282vertices
verticils1446182verticils
vesical12159812ve_sical
viatical1347062viatical
acritical1348133acritical
aerial64625713aer_i_al
aestival1145483aestival
berascal1244853berascal
bestial9311643besti_al
biotical1248863biotical
centrical1348353centrical
cercal10314123cer__cal
clerical1248233cler_ical
critical12310263critical
deifical1445543deifical
deistical1246673deistical
dentinal939503dentinal
detrital946573detrital
epical10413393_e_pical
erica7316543_er_ica_
ericas8315463_er_icas
eristical1148433_eristical
erotica92811513_erotica_
erratical1146903erratical
estival1036323_estival
ethical1238443_ethical
farcical1546953farcical
ferial94621253fer_i_al
festival1444713festival
fetial95716193fe_ti_al
fornical1347793fornical
genetical1247573genetical
georgical1344023georgical
germinal1147253germinal
haptical1547343haptical
helical12311153he_lical
hermetical1746383hermetical
hernial10310433herni_al
iatrical1049273iatrical
identical1246313identical
inertial8411723inerti_al
irenical1048553irenical
jerrican1794123jerrican
lenticel1066123lenticel
lexical1637363le_xical
lyrical1236493lyr_ical
martial92415413marti_al
medical12312513me_dical
meticals12310763me_ticals
mystical1546933mystical
nautical1057703nautical
optical1149863_optical
partial92616263parti_al
piratical1348663piratical
poetical12311533poetical
pyritical1646983pyritical
retial64724993re_ti_al
retinal75318353re_tinal
retrial7615553retri_al
rustical1048393rustical
sceptical1545343sceptical
serial64625863ser_i_al
serotinal947213serotinal
skeptical1743963skeptical
statical1039423statical
sterical10311253ster_ical
surgical1146253surgical
tactical1248843tactical
terminal1039733terminal
tertials8510073terti_als
tertian7511193terti_an
thetical1349123thetical
tical76021493___tical
turrical1046203turrical
veinal93812963ve__inal
venial94218283ve_ni_al
ventral103612173vent_ral
verbal112513663ver__bal
verdict1339583verdic_t
verdicts1446013verdicts
veritas103012753ver_itas
vermian12329713vermi_an
vernal93514213ver__nal
vernicle1346433vernicle
veronica1346733veronica_
veronicas1446393veronicas
verruca1243713verruca_
verrucae1343193verrucae
verrucas1343923verrucas
versal93013753ver__sal
versicle1366583versicle
versional1245863versional
vertebral1472803vertebral
verticality1955053verticality
vertigo1146133verti_go
vertigos1254973vertigos
vesica11157913ve_sica_
vesicae12177703ve_sicae
vestal94615573vest__al
vestigial1343773vestigial
vestral104111013vest_ral
vestural1156473vestural
viatica1245863viatica_
viaticals1444073viaticals
virginal1244573virginal
virtual1045913virt_ual
vortically1849193vortically
vortices1369123vortices

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621276.45322650.2
3Display Results1271270.0462760.9
 (SQL Overall)1786911276.93525766.5
 
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.