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 “espouse” 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
espouse93640(None) 
bespouse1245101bespouse
espoused1134851espoused
espouser1044381espouser
espouses1037301espouses
spouse84112511_spouse
bespoused1443752bespoused
bespouses1345142bespouses
espousal1083002espousal
espousers1143382espousers
expose1549522expo_se
response1037742response
scouse84113632_scouse
souse56530772_s_ouse
spoused10349652_spoused
spouses92912812_spouses
ampoule11116603ampoule
appose10411993appo_se
arouse65019983_arouse
asperse94210663asperse
bespoke15468113bespo_ke
blouse84714723_blouse
bouse75931853__bouse
carouse9614423carouse
chouse116017563_chouse
crouse84619363_crouse
delouse839833delouse
depose94215763depo_se
despise1038683desp_ise
despots10319683despots_
dispose10312763dispo_se
douse66329723__douse
effuse1234963e_ffuse
emprise11310723emprise
endorse879203endorse
enthuse1046963enthuse
epode85114093e_po_de
epodes94315563e_podes
epopee10312503e_popee
epos66723733e_po_s_
eposes84418783e_po_ses
erose55727273e_ro_se
escots84211743escots_
espies83716803espies_
espousals1152363espousals
espousing1265003espousing
estops84011223estops_
estrous7712533estrous_
estrus61912113estrus_
estruses838483estruses
excuse1537423e_xcuse
expanse16145603expanse
expense16127873expense
expos1449203expo_s_
exposed1737443expo_sed
exposer1637413expo_ser
exposes1639963expo_ses
exposure1743673exposure
expound1744373expound
expulse1674513expulse
gashouse1245693gashouse
grouse74315023_grouse
henhouse1445573henhouse
house89131423__house
impose103113053impo_se
louse56131013__louse
lupous849433lupous_
mesopause1352703mesopause
mispoise1248263mispoise
mouse77133003__mouse
oppose1039193oppo_se
osmose8108003osmo_se
osmous8138183osmous_
papoose1147513papoose
pause75021833__pause
pesthouse1445963pesthouse
poise75127893__poise
pose66441733__po_se
posse74722273__posse
rearouse839363rearouse
rehouse10311773rehouse
repose84121413repo_se
repousse1046053repousse
respoke134311283respo_ke
responsa1043583responsa
responses1147443responses
respots92912763respots_
rouse56634703__rouse
scouses93313243_scouses
sepoys1138473sepoys_
serous65023563serous_
setose65114773seto_se
setous64917373setous_
sous46947213_s_ous_
soused74822983_s_oused
souses64229243_s_ouses
sparse84516343_sparse
speise84614253_speise
spense83912433_spense
spode84617703_spo_de
spodes94817433_spodes
spoke114818663_spo_ke
spokes124417213_spokes
sponge939663_sponge
spore75428593_spo_re
spores84726613_spores
sporule937273_sporule
spots74424113_spots_
spousal965533_spousal
spout75029633_spou_t
spouted103412263_spouted
spouter94213223_spouter
spouts85115113_spouts
spruce103910873_spruce
sprue74717633_spru_e
sprues84515763_sprues
spue66025523_sp_u_e
spues75025383_sp_ues
spume95817313_sp_ume
stoure64814943_stoure
taphouse1346333taphouse
teahouse1146073teahouse
touse55430673__touse
unhouse1038923unhouse
uprouse937223uprouse
youse85322233__youse

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271266.20621596.4
3Display Results1261260.0304200.0
 (SQL Overall)1786911266.38927968.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.