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

198 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
echoic133904(None) 
anechoic1545372anechoic
chic115925202_ch_ic
choice132010522_choice
choir105313602_choir
choric133515902_choric
ecbolic1345622ecbolic
ecesic10369222ecesic
echo96615952echo__
echoed125211152echoed
echoer114011102echoer
echoes114715522echoes
echoey14397852echoey
echoing1358612echoing
echoism1447362echoism
echos105216462echo_s
ectopic1338152ectopic
enchoric1547102enchoric
ethic101511222eth_ic
ethnic1148852ethnic
technic1496902technic
acetic10314503acetic
acholia1239973acholia
achoo10315083acho_o
achromic1747613achromic
acidic113612133acidic
acinic104713543acinic
acmic11312333ac_mic
acronic112814693acronic
acrotic112515543acrotic
aphonic142713393aphonic
aphotic142913123aphotic
archaic1438823archaic
atechnic1554403atechnic
azoic162912063_azoic
benzoic2045033benzoic
ceboid11310653ceboid
ceric94023093_ceric
cerotic11415063cerotic
chai95929903_chai_
chain105723673_chain
chair105519633_chair
chais107530313_chais
chaotic14310043_chaotic
chemic153012093_chemic
chi86228653_ch_i_
chia96026623_ch_ia
chica125818263_ch_ica
chick165419133_ch_ick
chico124218253_ch_ico
chics123920943_ch_ics
chid106626403_ch_id
chin96934743_ch_in
chip116726423_ch_ip
chis95933313_ch_is
chit96937463_ch_it
chloric143410613_chloric
chock164316613_chock
choicer14197893_choicer
choices142010613_choices
choirs114911883_choirs
choke145118023_choke
choky175711223_choky
chola104718033_chola
cholo105217973_cholo
chomp144815663_chomp
chon96627793_cho_n
chook146015043_chook
chop116024923_cho_p
chopin132712193_chopin
chops125019873_chops
chord115917263_chord
chore105126763_chore
choreic1438703_choreic
chose105925403_chose
chott103923933_chott
chow125820993_cho_w
chows135618203_chows
chromic1639863_chromic
chronic14311423_chronic
chymic18317883_chymic
civic123412543_civic
clonic104914673_clonic
coif96337913_c_oif
coil66439653_c_oil
coin66645353_c_oin
coir66327243_c_oir
colic95726173_colic
comic114721813_comic
conic95329793_conic
croc85723733_cro_c
croci95818133_croci
cubic114313423_cubic
cynic124712423_cynic
dichotic1647663dichotic
dichroic1645723dichroic
ecbolics1444003ecbolics
ecesis84611203ecesis
echard1249223echard
eche97520283ech__e
eched116919223ech_ed
eches106322163ech_es
eching126315563eching
echini114710433echini
echinoid1445993echinoid
echoers12459693echoers
echoisms1546143echoisms
echolalic1653833echolalic
echt95722903ech__t
eclair836813eclair
ecologic1349563ecologic
economic1447863economic
ectatic11310123ectatic
ectopia1147693ectopia
edenic9310223edenic
eidolic1047063eidolic
elhi7612403elh_i_
eloin55923203e_loin
embolic1347423embolic
emetic10614453emetic
emic86422753e__mic
enatic8317563enatic
enchain1248863enchain
enjoin1357833enjoin
enolic8413353enolic
entoil6912493entoil
entopic1149953entopic
envoi878023envoi_
envois988703envois
ephebic1646513ephebic
ephod1139123epho_d
ephods1238363ephods
ephor10310013epho_r
ephori1139603ephori
ephors11311403ephors
epic86921303e__pic
epizoic2045193epizoic
ergodic1145503ergodic
ergotic1049723ergotic
erotic82620273erotic
essoin638193essoin
etheric12311783etheric
ethics11169283eth_ics
ethion938813ethion
ethmoid1345803ethmoid
ethnics1236263ethnics
ethos85514193etho_s
ethoxy1933923ethoxy
ethylic1546323ethylic
etic66123953e__tic
euphonic15117813euphonic
euphoric15107043euphoric
euphotic15117523euphotic
exhort16410803exhort
exilic1597783exilic
exonic153211413exonic
exotic153112653exotic
hectic132311523hec_tic
heroic113516923heroic
hic86540563__h_ic
hoick145210683__hoick
huic94818053__huic
ichor1039483icho_r
ichors11310423ichors
iconic10411593iconic
ictic9311803ic_tic
mechanic1747613mechanic
methodic1656923methodic
necrotic12310043necrotic
nephric1446213nephric
ochone11311293ochone
ochroid1357903ochroid
ohmic1237833_ohmic
pectic122913873pec_tic
phobic153010073_phobic
phonic133315213_phonic
photic133316443_photic
rechose121312043rechose
recoil84016723rec_oil
recoin84320293rec_oin
rhodic12227233_rhodic
rhotic112711233_rhotic
scenic10510513scenic
scholia1237833scholia
school11410723school
schorl1179813schorl
schrik15206703schrik
schtick18194523schtick
schtik15185423schtik
schuit1139563schuit
stoic7317253_stoic
techie11511723tech_ie
technics1585463technics
tectonic1248453tectonic
thoric114314043_thoric
unchic1338643unch_ic
zechin20137703zech_in
zoic152316073__zoic

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161985.43620735.1
3Display Results1981980.0633142.9
 (SQL Overall)1786911985.88930343.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.