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

100 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
expanded1914516(None) 
expander18145801expander
expended19136541expended
expand16236572expan__d
expanders19125092expanders
expandor18142762expandor
expands17195732expand_s
expanse16145602expanse_
expanses17156172expanses
expender18136842expender
expensed18126412expensed
explanted1944972explanted
exploded1944752exploded
expounded2042972expounded
expunged1942972expunged
extended17135832extended
appended1435483appended
banded105223173__banded
branded114414103_branded
demanded13348513demanded
depended1337983depended
desanded11227453desanded
desponded1445323desponded
embanked17253883embanked
emended11329603e_mended
empaled12288953empa_led
empanel1145963empan_el
empaneled1443433empaneled
emplaned1337163emplan_ed
ended74421263e___nded
enhanced1436623enhanced
enplaned1137483enplan_ed
evaded1137063e_va_ded
exacted1737303ex_acted
exalted1537393ex_alted
exapted1736073ex_apted
exceeded1943493exceeded
exchanged23113673exchanged
excided1836203ex_cided
excluded1943433excluded
exhaled1835283exha_led
expanding2044793expanding
expandors19142833expandors
expected2036743expected
expelled1895873expelled
expend16247503expen__d
expenders19145963expenders
expends17217083expend_s
expense16127873expense_
expenses17138373expenses
experted1838053experted
expiated18168523expiated
expired1736403exp_ired
explained1944543explained
explode1745963explode_
exploder1844843exploder
explodes1845803explodes
explored1845083explored
exported1837133exported
exposed1737443exp_osed
expounder1943273expounder
expulsed1863613expulsed
expunge1743313expunge_
expunger1843193expunger
expunges1843573expunges
exscinded2042223exscinded
extender16146333extender
extruded1743843extruded
exuded15317683ex__uded
handed114919983__handed
impended1435953impended
islanded1035513islanded
japanned1843143japanned
jeoparded2042053jeoparded
landed84619243__landed
padded114113503__padded
pander93725523__pander
pandied113913443__pandied
paned85437183__pan_ed
panged104722333__panged
panned94123433__panned
panted95024823__panted
pended103819013__pended
perpended1546083perpended
ponded105218773__ponded
relanded102410463relanded
remanded123011323remanded
respaded1238133respa_ded
responded1336513responded
sanded84920613__sanded
spaded103816753_spa_ded
spandex1735833_spandex
spanked143111733_spanked
spanned104111223_spanned
stranded102710813stranded
unbanded123010563unbanded
unexpended2142703unexpended
unhanded132910183unhanded
unpadded1345183unpadded
upended11267323_upended

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.423422437.4
2DLD Change Limit1461621006.90621164.5
3Display Results1001000.0303333.3
 (SQL Overall)1786911007.35924282.0
 
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.