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

153 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
nodical104986(None) 
codicil1246812codicil
comical13312222comical
conical11316202conical
domical1239372domical
gnomical1346682gnomical
logical1038512logical
medical12312512medical
modica11310062modica_
monodical1447002monodical
nadiral836342nadiral
nodal64717792nod__al
nominal92712372nominal
nudicaul1142252nudicaul
radical103312792radical
synodical1544792synodical
topical1139952topical
toxical1637642toxical
zodiacal2042242zodiacal
alodial899953alodi_al
alogical1147763alogical
anodal72512123anod__al
anodic92813133anodic__
anodically1648263anodically
apical10913903_apical
atomical1248903atomical
audial7312993audi_al
biotical1248863biotical
bodice11711423bodic_e
bodices12710593bodices
canonical1347213canonical
coccal9310223co_ccal
codices12512583codices
codicils1346043codicils
coital84117053co_ital
cordial10312953cordi_al
cortical12412213cortical
cosmical1448013cosmical
cotidal1038463cotidal
cubical1338463cubical
cynical1437873cynical
decal85523233__decal
dial55935063__di_al
domicil1246433domicil
ducal84816423__ducal
edictal1046993_edictal
epical10413393_epical
erotical101911983erotical
ethical1238443ethical
finical1239693finical
focal104917673fo__cal
fornical1347793fornical
gnostical1246203gnostical
helical12311153helical
iconical1248203iconical
indican1048243indican
inimical1247313inimical
iodic84816753iodic__
ironical1049963ironical
jovial1636543jovi_al
judicial1844643judicial
laical8312323_laical
lexical1637363lexical
local74820273lo__cal
lodicule1143263lodicule
lorica8310443lorica_
loricae938253loricae
lyrical1236493lyrical
magical1239783magical
medial93819863medi_al
medicals1349363medicals
metical11315363metical
mimical1339233mimical
modal85919243mod__al
modicum1445073modicum
monadical1446133monadical
musical1139553musical
narial6317953nari_al
nasial6413283nasi_al
nautical1057703nautical
nicad8312613n__icad
nicol71113293n__icol
nidal65217103n__idal
nival84915773n__ival
nodi56626743nodi___
nodular876703nodular
noil46133243no_i__l
nomina83113683nomina_
nominals10278613nominals
nonfinal1147703nonfinal
nonfiscal1444543nonfiscal
nonfocal1346443nonfocal
nonideal947303nonideal
nonlocal1047513nonlocal
nonmedical1566483nonmedical
nonoral7313603nonoral
nonrival1146623nonrival
nontidal948673nontidal
nonviral1146743nonviral
nonvital1147023nonvital
nonvocal1346123nonvocal
nopal75517103no__pal
nordic939473nordic__
noria55722183nori_a_
norias65518203nori_as
normal83213533no_rmal
notal55221353no__tal
notice8313443notic_e
noticed1037863noticed
noticer937273noticer
notices9312283notices
notional849403notional
nounal639813no_unal
novercal1345683novercal
novice1138433novic_e
novices1238223novices
ocicat101412813_ocicat
odic74920573_odic__
oedipal1045173oedipal
ogival1035873_ogival
optical1149863optical
ordinal838643ordinal
parodical1447563parodical
pedicab1446693pedicab
pedicel1237813pedicel
pedocal1237893pedocal
pical95524373__pical
plical10411683_plical
podia8415283podi_a_
poetical12311533poetical
pollical1247953pollical
prodigal1246003prodigal
radial74020393radi_al
radicals112610163radicals
radicel10278873radicel
redial74923113redi_al
social8813333soci_al
sodic84917493sodic__
somital939403somital
stoical9310283stoical
syndical1445373syndical
tical76021493__tical
tropical1248733tropical
typical1436343typical
vatical1239983vatical
vesical12159813vesical
vocal104715643vo__cal
vomica1336383vomica_
vomicae1445303vomicae
vortical1348863vortical
zodiac1835303zodi_ac
zodiacs1943423zodiacs
zooidal1745093zooidal

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.406440125.6
2DLD Change Limit1340271535.79623124.1
3Display Results1531530.0632428.6
 (SQL Overall)1786911536.26528522.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.