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

84 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
echelles134667(None) 
echelle1246621echelle_
echelons1385542echelons
achenes12313493ache_nes
achillea1344103achillea
achilleas1443263achilleas
belles85325993__belles
cadelles1139973cadelles
celled94420323_c_elled
cellos84517803_c_ellos
cells75428063_c_ell_s
challas124414123_challas
challies133915643_challies
challis124613463_challis
cheeses123613103_cheeses
chegoes1337333_chegoes
chelae113614603_chelae_
chelas113817203_che_las
chelates132713843_chelates
chenilles1444373_chenilles
cheques2136863_cheques
chesses124112633_chesses
chevies153511443_chevies
chevres15379793_chevres
chicles143512503_chicles
childes134211273_childes
chiles115425303_ch_iles
chilies124218303_chilies
chilled133310933_chilled
chiller124112183_chiller
chillers133710923_chillers
chillest13259593_chillest
chillies134113483_chillies
chillis124411603_chillis
chills114717703_chill_s
chollas123811353_chollas
chyles144813283_ch_yles
creoles9913323_creoles
duxelles1643963duxelles
echelon1276163eche_lon
echeloned1543443echeloned
eches106322163ech___es
echoes114715523ech__oes
echoless1345603echoless
enhaloes1197343enhaloes
entellus845173entellus
ephebes1436153ephe_bes
ethenes103313873ethe_nes
excelled18125693excelled
exhales1737143exh_ales
expelled1895863expelled
expellee17116093expellee
expellees18133803expellees
expeller17105783expeller
expellers18104743expellers
eyeholes1445593eyeholes
gabelles11278933gabelles
gazelles18266563gazelles
helled104024703__helled
heller93322513__heller
hellers103619833__hellers
helloes103717463__helloes
hellos95321683__hellos
hells85032043__hell_s
helves124316063__helves
lecheries1449073lecheries
micelles1288833micelles
morelles10710493morelles
nacelles1048393nacelles
ocellus935983oc_ellus
phellem1435833_phellem
phellems1544543_phellems
roselles8310713roselles
schedules1562953schedules
schemes1489663sche_mes
schiller13296473schiller
schillers14285663schillers
schmelzes2542673schmelzes
selles64426983__selles
shelled113815083_shelled
sheller103515883_sheller
shellers112812573_shellers
shells94319523_shell_s
shelves134112093_shelves

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162847.14020470.9
3Display Results84840.0332545.5
 (SQL Overall)178691847.32924381.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.