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

101 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
expanse1614560(None) 
expanses17156171expanses
expense16127871expense
expand16236572expan_d
expanded19145162expanded
expander18145802expander
expands17195732expands
expansile1843942expansile
expansive2144392expansive
expats1537682expats_
expensed18126412expensed
expenses17138372expenses
expose1549522exp_ose
expulse1674512expulse
expunge1743312expunge
bedpans1237173bedpans_
cleanse9358723cleanse
ease45042333e__a_se
elans55527753e_lans_
elapse857523e_lapse
empale102611263empa_le
empales112411433empales
empanel1145963empanel
emplane11410013emplan_e
emplanes1239503emplanes
emprise11310723emprise
encase83714363enca_se
enhance1239693enhance
enplane939723enplan_e
enplanes1039483enplanes
erase54925493e_ra_se
espanol943783espanol
espouse936403espouse
ethane94613243ethan_e
ethanes103713513ethanes
exams14199083ex_ams_
exchange21124323exchange
excise1538553ex_cise
excuse1537423ex_cuse
exhale1636873exha_le
exhales1737143exhales
exhaust1744243exhaust
exine125518493ex_in_e
exines135715803ex_ines
exons125813343ex_ons_
expanders19125093expanders
expandor18142763expandor
expansible2153553expansible
expansion1844443expansion
expat14313813expa__t
expels1547173expels_
expend16247503expen_d
expended19136543expended
expender18136843expender
expends17217083expends
expensive2145843expensive
expiable1946113expiable
expiate16910593expiate
expiates17810213expiates
expire1538023exp_ire
expires1638683expires
explains1766443explains_
explant16310133explan_t
explanted1944973explanted
explants1737023explants
explode1745963explode
explore1646613explore
expos1449203exp_os_
exposed1737443exp_osed
exposer1637413exp_oser
exposes1639963exp_oses
express1637493express
expulsed1863613expulsed
expulses1774813expulses
expunged1942973expunged
expunger1843193expunger
expunges1843573expunges
extant132714753extan_t
hanse85722793__hanse
hexane16379533hex_an_e
hexanes17319463hex_anes
impasse11246463impasse
japans1539823japans_
lipase8239103lipa_se
manse75528233__manse
paise75028333__paise
pane64950293__pan_e
panes76148693__panes
panne76623653__panne
pans65855733__pans_
pansy105717973__pansy
parse75236993__parse
pase65346863__pa_se
passe75525693__passe
pause75021833__pause
response1037753response
sextans14349273sextans_
spans74528733_spans_
sparse84516343_sparse
spense83912433_spense
teopans939203teopans_

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271016.62320236.6
3Display Results1011010.0333060.6
 (SQL Overall)1786911017.06225303.2
 
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.