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

193 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
acedias103977(None) 
acedia9310391acedia_
abelias93213562abelias
acacias11510402acacias
accidias1346332accidias
acequias1943972acequias
acetins9313172acetins
alexias14249792alexias
anemias92512142anemias
arcadias1149162arcadias
cardias10715112cardias
cedis84317082_cedi_s
cerias83321982_cerias
medias93620782_medias
redias74523602_redias
abasias9711013abasias
abelia83114403abelia_
abelian92810643abelian
abulias93210693abulias
acacia10311353acacia_
academias1444793academias
acapnias1255683acapnias
acarids105312243acarids
acceders1334793acceders
accedes1237723acced_es
acceding1446093acceding
accidia1246993accidia_
accidies1338043accidies
accredits1443433accredits
aced79540883aced___
aceldamas1472263aceldamas
acequia1844133acequia_
acerolas1048053acerolas
acerous9513333acerous
aces67645093ace___s
aceta74017353ace_ta_
acetal84314903ace_tal
acetals93411353acetals
acetic10314503aceti_c
acetify1545003acetify
acetin8314693aceti_n
acetous9410363acetous
acetyls12285353acetyls
achenial1348283achenial
acholias1349573acholias
acidemias1444503acidemias
acidic113612133acidi_c
acidify1645243acidify
acidity1338593acidity
acids87121003ac__ids
acidurias1243233acidurias
acquits1857293acquits
acrasias1048893acrasias
actinias101810843actinias
actins86321103ac_tins
adios65822863a__dios
adits66523713a__dits
aecia73819283a_ecia_
aecial84817313a_ecial
aecidia1047283aecidia_
aecidial1147253aecidial
aedes64625143a_ed_es
aedile73716653a_edile
aediles83413903a_ediles
aedine73218393a_edine
aegis6316783a_egi_s
aerial64625713a_erial
aerials74017553a_erials
aeries64737783a_eries
agendas936933agendas
agrias74315393a_grias
akelas10311193ake_las
alevins102110573alevins
alexia132910463alexia_
alexins141910663alexins
alias55834603a__lias
alodia71112453alodia_
alodial899953alodial
amebas10311453ame_bas
amentias1039413amentias
amias75831473a__mias
amidins103713103amidins
amnesias1047833amnesias
amusias938583amusias
anaemias1069203anaemias
anemia82613573anemia_
anergias947173anergias
anopias92412483anopias
anoxias14259113anoxias
anurias7312253anurias
aperies9423203aperies
aporias9315153aporias
arcadia1039703arcadia_
arcadian1147763arcadian
arcadians1245083arcadians
areas55935773are__as
arecas84817443are_cas
arenas65021993are_nas
areolas71013863areolas
arepas85515703are_pas
arias55438023a__rias
ascesis938373ascesi_s
ascetics1247073ascetics
ascidia1046683ascidia_
ascidian1145633ascidian
ascidians1244503ascidians
asdics9439863a_sdics
asterias8317013asterias
ataxias14189343ataxias
atonias73315993atonias
atresias839473atresias
audial7312993a_udial
audios72312283a_udios
audits72814113a_udits
avidins11349003avidins
babesias1246113babesias
bacterias1349283bacterias
bedims1149593_bedims
beedies10314203beedies
cachexias2363383cachexias
caddies113718383caddies
caddis104613383caddi_s
cadis84428503_cadi_s
caeomas1138403caeomas
camelias12510303camelias
candidas12338643candidas
candids113812693candids
candies104125613candies
capias10318353_capias
cardia9916373cardia_
cardiac1278813cardiac
cardiacs1376913cardiacs
cardiae10713703cardiae
cassias93514343cassias
cebids11439173_cebids
cedar84014323_ced_ar
cedars93312833_cedars
ceders93817673_ceders
cedes84927323_ced_es
cedi74919273_cedi__
cedillas1145743_cedillas
ceding104014803_ceding
cedulas1058503_cedulas
ceibas1038503_ceibas
ceils75019403_ce_ils
celiac101910433_celiac
celiacs11157893_celiacs
centas85020703_centas
ceria75125353_ceria_
cestas85018543_cestas
chias104625523_c_hias
cobias104014993_cobias
codas84724243_cod_as
codeias103911223_codeias
coedits10310243coedits
credits1039973credits
ecesis84611203ecesi_s
edits65819033__edits
facetiae1346213facetiae
facias113415803fac__ias
ferias95020393_ferias
khedas1446313khed_as
media84721713_media_
mediad104313713_mediad
mediae94217413_mediae
medial93819863_medial
medials103914733_medials
median94117543_median
medians103214213_medians
medics114115353_medics
medinas103411463_medinas
medius93613283_medius
obelias9279033obelias
predial103815413predial
pyemias1436803pyemias
redia65524483_redia_
rediae74221993_rediae
redial74923113_redial
redials84416883_redials
redips93713843_redips
reedits8511743reedits
scandias1137863scandias
scenas84114703sce_nas
scenics1137773scenics
scotias939753scotias
sepias83616103_sepias
stadias8411113stadias
taenias7311283taenias
tenias64720073_tenias
uredia73610063uredia_
uredial82910483uredial
uremias9249503uremias
xenias133712973_xenias

Search took 8 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.1731032896.0
2DLD Change Limit1340271937.14018771.3
3Display Results1931930.0603216.7
 (SQL Overall)1786911937.37324235.9
 
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.