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

126 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
excelled1812569(None) 
expelled1895871expelled
celled94420322__celled
exceed1636172exce__ed
exceeded1943492exceeded
excellent1844572excellent
excepted2055232excepted
excessed1844942excessed
expellee17116092expellee
expeller17105782expeller
extolled1654302extolled
unexcelled2042032unexcelled
belled94626183__belled
bevelled14327793bevelled
bowelled1446173bowelled
called94126733__called
cancelled1456743cancelled
ceiled94114953__ceiled
culled94022473__culled
cupelled1365743cupelled
defuelled1443123defuelled
dowelled1356343dowelled
duelled9359753_duelled
dwelled12337593_dwelled
easeled8159853ease_led
echelle1246623echelle_
echelles1346673echelles
emceed1136283emce__ed
enamelled1244613enamelled
enrolled967963enrolled
equalled1834863equalled
exalted1537393ex_alted
exampled2043353exampled
exceeder1843953exceeder
exceeds1733843exce__eds
excel1437743exce_l__
excellence2152713excellence
excellency2451953excellency
excelling1935643excelling
excels1536663exce_l_s
excerpted2153873excerpted
excesses1736753excesses
excided1836203exc_ided
exciple1874683exciple_
exciples1964773exciples
excised1736673exc_ised
excited1737853exc_ited
exclude1744453exc_lude
excluded1943433excluded
excreted1846153excreted
excused1736293exc_used
executed1835503executed
exerted152210053ex_erted
exhaled1835283ex_haled
exiled144712463ex__iled
expected2036743expected
expellees18133803expellees
expellent1845273expellent
expellers18104743expellers
expended19136543expended
expensed18126413expensed
experted1838053experted
expulsed1863613expulsed
exsected1835673exsected
exserted1636213exserted
extended17135833extended
extoller1564173extoller
exulted1536303ex_ulted
felled103720303__felled
ferrelled1343933ferrelled
fuelled11369193_fuelled
gabelled12317583gabelled
gavelled13387363gavelled
gelled84718893__gelled
gruelled1034893gruelled
helled104024703__helled
hovelled15146843hovelled
impelled1336073impelled
jelled144916063__jelled
jewelled1934333jewelled
kennelled1443503kennelled
kernelled1443733kernelled
knelled12338993_knelled
kvelled15276063_kvelled
labelled11278293labelled
lapelled11227083lapelled
levelled12327443levelled
libelled11317213libelled
marcelled1445203marcelled
melled95023023__melled
micelle1178343micelle_
micelles1288833micelles
modelled1236433modelled
nacelle938153nacelle_
nacelles1048393nacelles
nickelled1653793nickelled
panelled1138963panelled
parcelled1445783parcelled
pencilled1445643pencilled
quelled17279273_quelled
ravelled12419783ravelled
rebelled113110323rebelled
recalled11310803recalled
reexpelled2052103reexpelled
refelled122810163refelled
refuelled1364503refuelled
repelled113111583repelled
respelled1257043respelled
revelled123712733revelled
rowelled1236633rowelled
sculled102911693_sculled
shelled113815083_shelled
smelled103511853_smelled
snelled83313043_snelled
spelled103714733_spelled
swelled113211693_swelled
teaselled1045123teaselled
teazelled1943733teazelled
towelled1236353towelled
umbelled1336273umbelled
uncalled11810923uncalled
upwelled1434663upwelled
weaselled1344183weaselled
welled103820213__welled
yelled104116253__yelled
yodelled1334603yodelled

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621266.26623326.2
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.73226543.5
 
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.