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

60 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
echelon127616(None) 
echelons1385541echelons
echelle1246622echelle
echeloned1543442echeloned
aphelion1375623aphelion
bachelor1564073bachelor
belon73924113__belon
celom9515693_c_elom
chalone12312103_chalone
chalot113020133_chalot
chegoe1237273_chegoe
chela103916803_chel_a
chelae113614603_chelae
chelas113817203_chelas
cheloid13310833_cheloid
chemo12313633_chemo_
chemos13311723_chemos
chevron1575783_chevron
chiton112612393_chiton
cholo105217973_cholo_
cholos114716853_cholos
chon96627793_ch__on
clon66232483_c__lon
coelom10310433_coelom
colon78630193_c_olon
crepon1039943_crepon
ecdyson1342213ecdyson
eche97520283eche___
eched116919223eche__d
echelles1346673echelles
echeloning1642863echeloning
eches106322163eche__s
echo96615953ech__o_
echos105216463ech__os
eidolon844913eidolon
elevon977953e_levon
enhalo987563enhalo_
enhalos1087533enhalos
enteron7313343enteron
envelop1243323envelop
epheboi1442983epheboi
ephebos1444113ephebos
epsilon944293epsilon
erelong835593e_relong
eschalot1346223eschalot
etalon648973e_talon
ethephon1643473ethephon
ethion938813eth_ion
eudemon1064753eudemon
felon84619293__felon
halon86124863__halon
helo75332853__helo_
helos84928063__helos
helot85332683__helot
heron85025503__heron
melon73922083__melon
ocelot8813383oc_elot
pelon74423213__pelon
phylon14318033_phylon
schuln11256233schul_n

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.390458182.1
2DLD Change Limit134027605.93622578.7
3Display Results60600.0163750.0
 (SQL Overall)178691606.34228175.8
 
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.