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

81 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
espouser104438(None) 
espouse936401espouse_
espoused1134851espoused
espousers1143381espousers
espouses1037301espouses
bespouse1245102bespouse_
bespoused1443752bespoused
bespouses1345142bespouses
espousal1083002espousal
exposer1637412expo_ser
spouse84112512_spouse_
spoused10349652_spoused
spouses92912812_spouses
spouter94213222_spouter
apposer1147483appo_ser
arouser74514423_arouser
asperser10408303asperser
carouser1068843carouser
chouser125212943_chouser
delouser936363delouser
deposer104011843depo_ser
despiser1136343desp_iser
despoiler1243963despoiler
disposer11310403dispo_ser
douser75621633__douser
embosser1244283embosser
empower14217033empo_wer
endorser966733endorser
eposes84418783e_po_ses
espalier1036363espalier
espousals1152363espousals
espousing1265003espousing
estruses838483estruses
excuser1635813e_xcuser
exporter1737363exporter
expose1549523expo_se_
exposed1737443expo_sed
exposers1736133expo_sers
exposes1639963expo_ses
exposure1743673exposure
expounder1943273expounder
grouser84513693_grouser
houser95322283__houser
imposer113310103impo_ser
mouser85822443__mouser
opposer1135773oppo_ser
pauser84415963__pauser
poiser84217243__poiser
poser75128773__po_ser
pourer84516043__pourer
pouter83923983__pouter
reposer93715333repo_ser
responder1246453responder
response1037743response_
responses1147443responses
rouser65224083__rouser
scourer93910433_scourer
scouse84113633_scouse_
scouses93313243_scouses
scouter93313323_scouter
shouter103213073_shouter
sourer63620213_s_ourer
souse56530773_s_ouse_
soused74822983_s_oused
souses64229243_s_ouses
souter64225923_s_outer
sparser94311483_sparser
spoiler93310683_spoiler
sponger1038523_sponger
sponsor934963_sponsor
spoofer12368723_spoofer
spooler93711383_spooler
sporter93616553_sporter
spotter94514873_spotter
spousal965533_spousal
spouted103412263_spouted
spouters104011143_spouters
sprucer11317683_sprucer
stouter74012053_stouter
trouser73812463_trouser
vapourer1344263vapourer

Search took 9 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.1731032896.0
2DLD Change Limit146162818.39017421.0
3Display Results81810.0631285.7
 (SQL Overall)178691818.62620715.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.