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

41 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
echelon1276161echelon
echelle1246622echelle
echelons1385542echelons
achoo10315083ach__oo
bachelor1564083bachelor
cello74919583_c_ello
celom9515693_c_elom
chalot113020133_chalot
cheapo134810083_cheapo
cheero114712943_cheero
chegoe1237273_chegoe
chela103916803_chel_a
chelae113614613_chelae
chelas113817203_chelas
cheloid13310833_cheloid
chemo12313633_che_mo
chemos13311723_chemos
cheroot12413693_cheroot
cholo105217973_chol_o
cholos114716853_cholos
coelom10310433_coelom
eche97520283eche___
eched116919223eche__d
echelles1346673echelles
echeloned1543443echeloned
eches106322163eche__s
echo96615953ech___o
echos105216463ech__os
enhalo987573enhal_o
enhalos1087533enhalos
envelop1243323envelop
epheboi1442983epheboi
ephebos1444113ephebos
eschalot1346223eschalot
helio85321193__helio
hello86522983__hello
helo75332853__hel_o
helos84928063__helos
helot85332683__helot
ocelot8813383oc_elot
scherzo2153943scherzo

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 Limit134027415.79623124.1
3Display Results41410.0133153.8
 (SQL Overall)178691416.19928825.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.