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

126 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
eidetic103974(None) 
edenic9310222e_denic
eidolic1047062eidolic
eirenic939002eirenic
emetic10614452e_metic
endemic1237892endemic
epidemic1545302epidemic
epidotic1346882epidotic
geodetic1246322geodetic
identic1038042_identic
kinetic13209172kinetic
mimetic1338652mimetic
acetic10314503_acetic
acidotic1355983acidotic
akinetic1455953akinetic
aloetic9313183aloetic
aphetic142912853aphetic
ascetic11310063ascetic
atretic9313923atretic
auxetic1637143auxetic
bidet84935623bidet__
bidets95215533bidet_s
bioethic1544693bioethic
biontic1148333biontic
bioptic1337563bioptic
biotic103816613bi_otic
cometic131215723cometic
cretic102816283_cretic
deictic1237703dei_ctic
deistic10311173dei_stic
deltic9312503__deltic
demic105119193__demic
detick1339383__detick
diabetic1346553diabetic
didactic1445183didactic
dieretic1148763dieretic
dietetic1146803dietetic
dimeric12310023dimeric
dimetric1348663dimetric
dineric10310973dineric
diuretic1146993diuretic
docetic1239913docetic
ecesic10369223e_cesic
eclectic1156073eclectic
ectatic11310123ectatic
eide55832243eide___
eider64624743eide__r
eiders74321363eide_rs
ekistic1377843ekistic
elastic93013393elastic
emetics11610723e_metics
emetin8613463e_metin
enatic8317563e_natic
endemics1346273endemics
endermic1356173endermic
enteric9314213enteric
enthetic131110613enthetic
enuretic1046993enuretic
ephebic1646513ephebic
epidemics1643993epidemics
epidermic1643753epidermic
epigeic1245983epige_ic
epigenic1347483epigenic
epileptic1544173epileptic
epimeric1476763epimeric
epithetic1666413epithetic
equisetic2042773equisetic
erethic1257723e_rethic
ergotic1049723ergotic
eristic9814093eristic
erotic82620273e_rotic
erratic9311123erratic
esthetic13119773esthetic
etheric12311783etheric
etic66123953___etic
eugenic1038603eugenic
eupeptic1444463eupeptic
eutectic1245503eutectic
exegetic1844893exegetic
exotic153112653e_xotic
fideistic1544023fideistic
fistic11812573fi_stic
gametic12310003gametic
genetic101211783genetic
geodesic1243563geodesic
geodetics1344463geodetics
godetia945353godetia
hebetic1438633hebetic
heretic12314833heretic
hermetic15310243hermetic
herpetic1547773herpetic
hidrotic1446903hidrotic
ictic9311803_i_ctic
idiotic1037463_idiotic
irenic8311103_irenic
iritic83213823_iritic
jaditic1746703jaditic
kinesic13257023kinesic
kinetics14207253kinetics
kinetin11248263kinetin
kismetic1644883kismetic
limnetic1255583limnetic
litotic939243litotic
luetic8310383_luetic
meiotic11410933mei_otic
miotic103715753mi_otic
mitotic1139713mitotic
noetic8514043_noetic
paretic113016673paretic
peridotic1446483peridotic
piratic11314293piratic
poditic122611583poditic
poetic10416843_poetic
pyretic143210783pyretic
sidekick1442633sidekick
sideritic1255353sideritic
siderotic1255343siderotic
syndetic1446033syndetic
tabetic1138463tabetic
thetic11412893_thetic
tiderip1045513tiderip
tonetic9313433tonetic
uretic82914353_uretic
viatic11311453vi_atic
vidette1167543vidette
viremic1436153viremic

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.423422437.4
2DLD Change Limit1340271266.22021547.7
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.68926714.2
 
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.