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 “aecidia” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
aecidia104729(None) 
accidia1247001accidia
aecidial1147251aecidial
ascidia1046681ascidia
accidias1346332accidias
accidie1247732accidie
acedia9310402a_cedia
acidic113612132a_cidic
aecia73819282aec__ia
aecidium1345282aecidium
arcadia1039702arcadia
ascidian1145632ascidian
decidua1144492decidua
peridia10312372peridia
acacia10311353a_cacia
accidies1338043accidies
acedias1039783a_cedias
acequia1844143acequia
acid77533403a_cid__
acidemia1344783a_cidemia
acidify1645243a_cidify
acidity1338593a_cidity
acidly125211793a_cidly
acids87121013a_cid_s
aciduria1143693a_ciduria
acidy117214903a_cid_y
acini75718983a_cini_
acinic104713543a_cinic
actinia91710863actinia
aecial84817313aeci_al
aecium10410423aeci_um
aerobia939473aerobia
albizia1864093albizia
alcid85817973alcid__
alcidine1148233alcidine
alcids94812293alcid_s
allodia8128793allodia
alodia71112453a_lodia
amidic114012873a_midic
amidin94015673a_midin
ancilla948603ancilla
aphidian1445533aphidian
arcadian1147763arcadian
arcadias1149163arcadias
ascidians1244503ascidians
ascidiate1245333ascidiate
ascidium1344813ascidium
ascitic1139323ascitic
avidin103510843a_vidin
basidia1047623basidia
caecilian1344013caecilian
cilia73016763__cilia
coccidia1244013coccidia
conidia1069303conidia
ctenidia1143023ctenidia
decide104116873decid_e
decided124312423decided
decider114213183decider
decides114217653decides
deciding132210833deciding
deciduae1243743deciduae
decidual1244203decidual
deciduas1243463deciduas
deliria868313deliria
echidna1343723_echidna
gonidia975903gonidia
media84721713me__dia
melodia1038883melodia
meridian1147683meridian
oidia6314963__oidia
peculia1147133peculia
peridial11411923peridial
praesidia1243333praesidia
presidia1147273presidia
pycnidia1642873pycnidia
pygidia1444193pygidia
pyxidia2043843pyxidia
redia65524483re__dia
residua8286623residua
sedilia847243sedilia
vaccinia1543373vaccinia
veridic1338143veridic

Search took 9 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.470380193.6
2DLD Change Limit134027827.80017182.9
3Display Results82820.0302733.3
 (SQL Overall)178691828.30021529.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.