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

136 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
expense1612787(None) 
expanse16145601expanse
expensed18126411expensed
expenses17138371expenses
expanses17156172expanses
expels1547172expels_
expend16247502expen_d
expended19136542expended
expender18136842expender
expends17217082expends
expensive2145842expensive
expose1549522exp_ose
expulse1674512expulse
expunge1743312expunge
spense83912432_spense
appease1137913appease
arpens84814823arpens_
aspens85013353aspens_
asperse94210663asperse
cense75121403__cense
copens106119963copens_
deepens10307813deepens_
defense1137503defense
dense65923503__dense
dispense11129783dispense
emprise11310723emprise
entente7412953entente
eocene8311613eocen_e
epee64628503e_pe__e
epees75219833e_pees_
espouse936403espouse
essence947673essence
ethene93312923ethen_e
ethenes103313873ethenes
eupepsy1442093eupepsy
evens84817103e_vens_
examens1637193examens_
excels1536663excels_
excess1546053exce_ss
excessed1844943excessed
excesses1736753excesses
excise1538553ex_cise
excuse1537423ex_cuse
execs14539723ex_ecs_
exes116530813ex_e_s_
exigence1846563exigence
exine125518493ex_in_e
exines135715803exines_
exogens1536883exogens_
exons125813343ex_ons_
expand16236573expan_d
expanded19145163expanded
expander18145803expander
expands17195733expands
expansile1843943expansile
expansive2144393expansive
expats1537683expats_
expect1758903expe_ct
expected2036743expected
expecter1936513expecter
expects1866883expects
expedite1847263expedite
expel1448233expe__l
expelled1895883expelled
expellee17116093expellee
expeller17105793expeller
expenders19145963expenders
expensing1946003expensing
expert15515353expe_rt
experted1838053experted
expertise1847933expertise
experts1659063experts
expiate16910593expiate
expire1538023exp_ire
expires1638683expires
explode1745963explode
explore1646613explore
expos1449203exp_os_
exposed1737453exp_osed
exposer1637413exp_oser
exposes1639963exp_oses
express1637493express
expressed1946213expressed
expresser1845733expresser
expresses1837863expresses
expresso1743883expresso
expulsed1863613expulsed
expulses1774813expulses
expunged1942973expunged
expunger1843193expunger
expunges1843573expunges
extend14267523exten_d
extended17135833extended
extender16146333extender
extends15227113extends
extensile1645033extensile
extensive1945723extensive
extensor1543913extensor
extent132714913exten_t
extents142610173extents
externe1438573externe
externes1539833externes
externs1438233externs_
flense938903_flense
immense1135293immense
incense92410303incense
intense72511903intense
lense54523433__lense
license9148423license
mense75025633__mense
offense1343683offense
opens76118553_opens_
pease75231113__pease
peise75825773__peise
pence94924453__pence
penes75839223__penes
penne75423853__penne
pens65649643__pens_
pensee8417313__pensee
perse75429523__perse
prepense12238943prepense
propense122410103propense
reopens939373reopens_
response1037753response
ripens85012173ripens_
sense55526823__sense
sixpence1943543sixpence
speise84614253_speise
spence103813793_spence
spenses92913573_spenses
suspense10135743suspense
tenpence1246403tenpence
tense55225843__tense
terpene92310863terpen_e
terpenes102111573terpenes
unpens82511013unpens_

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 Limit1340271366.95019284.5
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.41924085.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.