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

91 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
echoism144736(None) 
echoisms1546141echoisms
chrism13710672_chrism
echoes114715522echoes_
echoic1339042echoi_c
echoing1358612echoing
echos105216462echo_s_
egoism977472e_goism
machoism1746392machoism
schism1338172sch_ism
acrotism1248223acrotism
aphorism1548643aphorism
archaism1547103archaism
atheism1248523atheism
chais107530313_chais_
chaise114916413_chaise
charism14712203_charism
chasm125518793_ch_asm
chemism16339303_chemism
chiasm13449103_chiasm
chirm125317063_ch_irm
chis95933313_ch_is_
choice132010523_choice
choir105313603_choi_r
choirs114911883_choirs
choose115116143_choose
choosy14459103_choosy
chops125019873_chops_
chose105925403_cho_se
chouse116017563_chouse
choush14549063_choush
chows135618203_chows_
chowse144711753_chowse
chrisma1456823_chrisma
chrisms1499143_chrisms
chrisom1466623_chrisom
civism1337243_civism
clonism1138983_clonism
cubism12348703_cubism
dichroism1744283dichroism
dodoism1135893dodoism
ecesis84611203ecesis_
eches106322163ech_es_
eching126315563ech_ing
echini114710433ech_ini
echo96615953echo___
echoed125211153echo_ed
echoer114011103echo_er
echoers12459693echoers
echoey14397853echo_ey
echogram1646393echogram
echoless1345603echoless
egoisms1065953e_goisms
egoist7612283e_goist
egotism1038353egotism
elitism939763elitism
embolism1446793embolism
envois988703envois_
eonism83213533e_onism
ephods1238363ephods_
ephors11311403ephors_
epizoism2163513epizoism
ergotism1146273ergotism
erotism9312303erotism
escapism1444453escapism
etatism9610293etatism
ethos85514193etho_s_
euphuism1543513euphuism
exotism1638123exotism
heroism12311013heroism
hoboism1446623hoboism
hoise85224773__hoise
hoist86433213__hoist
holism113713753__holism
ichors11310423ichors_
locoism1156793locoism
machoisms1845193machoisms
mechanism1846563mechanism
methodism1745243methodism
nephrism1544793nephrism
rechoose13137343rechoose
rechose121312043recho_se
schisms1437173sch_isms
schist11312653sch_ist
scholium1545643scholium
sciolism1247093sciolism
tachism1478873tach_ism
tectonism1346203tectonism
theism1139483_theism
wholism1535883_wholism
yahooism1643013yahooism

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.406440125.6
2DLD Change Limit134027916.64020184.8
3Display Results91910.0332757.6
 (SQL Overall)178691917.07925242.4
 
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.