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

185 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
vatical123998(None) 
viatical1347061viatical
apical10913902_apical
datival1135582datival
haptical1547342haptical
iatrical1049272iatrical
laical8312322la_ical
magical1239782magical
matinal9312602matinal
metical11315362metical
nautical1057702nautical
optical1149862optical
radical103312792radical
statical1039422statical
tactical1248842tactical
tical76021492__tical
vaginal11288402vaginal
vatic10316422vatic__
vaticinal1444572vaticinal
venatical1446792venatical
vertical13410432vertical
vesical12159812vesical
viatica1245862viatica_
viaticals1444072viaticals
vortical1348862vortical
abapical1444943abapical
actinal9312293actinal
aecial84817313_aecial
agnatical1246163agnatical
animal85016253_animal
anticar9312663anticar
apicals1159923_apicals
atabal839743_atabal
atomical1248903_atomical
atonal6514023_atonal
atrial65418943_atrial
atypical1544683_atypical
axial124515193_axi_al
basinal9310033basinal
bathyal1544823bathyal
biotical1248863biotical
caecal103713733ca_ecal
capital112311523capital
caracal11312513caracal
carinal94318233carinal
catcall1139153cat_call
comical13312223comical
conical11316203conical
cortical12412213cortical
cotidal1038463cotidal
critical12310263critical
cubical1338463cubical
cynical1437873cynical
domical1239373domical
epical10413393_epical
erotical101911983erotical
erratical1146903erratical
estival1036323estival
ethical1238443ethical
facial113615633faci_al
faecal11359813fa_ecal
fanatical1446483fanatical
farcical1546953farcical
fascial1258303fascial
fatal84819373fat__al
fatidical1544243fatidical
faucal11339963fa_ucal
faucial1257323faucial
fetial95716193feti_al
finical1239693finical
gavial10310083gavi_al
gestical1138983gestical
hectical1547933hectical
helical12311153helical
intimal9109943intimal
jacal14313703ja__cal
labial84714343labi_al
laminal94113633laminal
lanital7310913lanital
lateral7313573lateral
latices9313763latices
latilla737953latilla
latina65621143latina_
latinas74416463latinas
lexical1637363lexical
logical1038513logical
lyrical1236493lyrical
maniacal1246723maniacal
marital92314183marital
martial92415413marti_al
maximal18347093maximal
medical12312513medical
meticals12310763meticals
metrical12311593metrical
mimical1339233mimical
musical1139553musical
mystical1546933mystical
mythical1845033mythical
nadiral836343nadiral
narial6317953nari_al
nasial6413283nasi_al
natal53921493nat__al
national8311533national
natural739513natural
nodical1049863nodical
oatmeal944973oatmeal
optimal1145783optimal
ovarial1037613ovari_al
ovational1246853ovational
paginal10269493paginal
partial92616263parti_al
pascal10812373pa_scal
pataca10311193pataca_
patacas11311003patacas
patina86022193patina_
patinae95414403patinae
patinas96318523patinas
pical95524373__pical
piratical1348663piratical
plical10411683_plical
poetical12311533poetical
practical1548843practical
racial83419243raci_al
radial74020393radi_al
radicals112610153radicals
radicel10278873radicel
rascal8511123ra_scal
ratal55025113rat__al
rational8412543rational
retial64724993reti_al
retinal75318353retinal
rustical1048393rustical
sahiwal1344443sahiwal
satanical1145413satanical
satirical1146873satirical
satyrical1445033satyrical
septical1259363septical
spatial9310323spati_al
stoical9310283stoical
taxicab1843413taxicab
thetical1349123thetical
ticals83214713__ticals
tidal64516443__tidal
tincal83913363__tincal
topical1139953topical
toxical1637643toxical
tragical1148213tragical
typical1436343typical
vaccinal1544903vaccinal
vagal94613633va__gal
vagina102710933vagina_
vaginae11377683vaginae
vaginas11298813vaginas
vail75432553va_i__l
vakil1259793vaki__l
valval12398863va_lval
vandal103713833va_ndal
vanilla10238743vanilla
varia85824203vari_a_
varias95019903vari_as
varices123313573varices
varietal1145613varietal
variola1068893variola
vasal85516293va__sal
vassal979243va_ssal
vatful12107083vat_ful
vaticide1446863vaticide
veinal93812963v_einal
venial94218283veni_al
verticals1457243verticals
verticil1366913verticil
vesica11157913vesica_
vesicae12177703vesicae
vial76731093v__i_al
viatic11311453viatic__
viaticum1542733viaticum
vicar10513863v__icar
vicinal12268543vicinal
viminal12288823viminal
vinal85725813v__inal
viral86419593v__iral
vital84819673v__ital
vocal104715643v__ocal
vomica1336383vomica_
vomicae1445303vomicae

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.390458182.1
2DLD Change Limit1340271855.89022755.0
3Display Results1851850.0802312.5
 (SQL Overall)1786911856.36028096.1
 
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.