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

71 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
espousers114338(None) 
espouser1044381espouser_
espouses1037301espouse_s
bespouses1345152bespouse_s
espousals1152362espousals
espouse936402espouse__
espoused1134852espouse_d
exposers1736132expo_sers
spouses92912812_spouse_s
spouters104011162_spouters
apposers1236283appo_sers
arousers84810983_arousers
aspersers11377243aspersers
bespouse1245113bespouse__
bespoused1443763bespouse_d
carousers1156743carousers
chousers134610203_chousers
delousers1044663delousers
deposers11359243depo_sers
despisers1245153desp_isers
despoilers1343533despoilers
disposers1238373dispo_sers
dousers84817273__dousers
embossers1343413embossers
empowers15276843empo_wers
endorsers1046123endorsers
eposes84418783e_po_se_s
espaliers1144123espaliers
espousal1083013espous_al
espousing1265003espousing
estovers1136453esto_vers
estruses838483estruse_s
excusers1734443e_xcusers
exporters1846253exporters
exposer1637413expo_ser_
exposes1639963expo_se_s
exposures1843483exposures
expounders2042663expounders
grousers93810733_grousers
housers104717813__housers
imposers12278463impo_sers
mousers95216443__mousers
opposers1244973oppo_sers
pausers94113223__pausers
poisers94214433__poisers
posers84223973__po_sers
pourers93513673__pourers
pouters94221873__pouters
reposers102911603repo_sers
responders1345773responders
responses1147453response_s
rousers75220143__rousers
scourers10348533_scourers
scouses93313243_scouse_s
scouters103411323_scouters
shouters113510623_shouters
souses64229243_s_ouse_s
souters74422603_s_outers
spoilers10238633_spoilers
spongers1137603_spongers
sponsors1045753_sponsors
spoofers13307323_spoofers
spoolers10349363_spoolers
sporters103714063_sporters
spotters104313383_spotters
spousals1064353_spousals
spouse84112513_spouse__
spoused10349653_spouse_d
spouter94213223_spouter_
trousers83910633_trousers
vapourers1443373vapourers

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 Filter1786911486410.403443402.0
2DLD Change Limit148641716.20623951.2
3Display Results71710.0302366.7
 (SQL Overall)178691716.63926915.3
 
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.