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

157 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
spondees113648(None) 
spondee10310591spondee_
ponders103618852_ponders
pongees104212542_pongees
sonders83820712s_onders
sondes74922872s_ond_es
spandexes1943452spandexes
spenders113211742spenders
spindles112710352spindles
spodes94817432spo_d_es
spongers1137602spongers
sponges10311042spon_ges
standees93310142standees
apogees1037103apo_gees
bendees103913863_bendees
blondes104213163blond_es
bonders104120663_bonders
condoes104319203_condoes
congees103517923_congees
donees74519493_don_ees
donnees84210363_donnees
epodes94315563epo_d_es
epopees1137233epo_pees
fondles113512613_fondles
fondues11399313_fondues
grandees103211283grandees
hondles113614523_hondles
mondes94322353_mond_es
panders103423743_panders
pandies104224503_pandies
pensees9311203_pensees
pinders103720483_pinders
polders103617373_polders
pollees93215333_pollees
ponces104720843_pon_ces
ponded105218773_pond_ed
ponder94521703_pond_er
pondered126411293_pondered
ponderer112410193_ponderer
ponderers12248453_ponderers
ponds85323403_pond__s
pondweed1543103_pondweed
pondweeds1642183_pondweeds
pones74547043_pon__es
pongee94920193_pongee_
ponies84833463_pon_ies
pontes83627853_pon_tes
poodles103013513_poodles
pounders113113293_pounders
powders134111553_powders
responders1345773responders
rondels82510053_rondels
sanders84025943s_anders
saponines1148043saponines
saponites1139943saponites
scolders11288993scolders
sconces113811453scon_ces
scones84521303scon__es
scowders14276233scowders
seconders1236953seconders
secondes1138133second_es
senders83022353s_enders
shandies122714113shandies
shindies122610503shindies
shoddies1336053shoddies
signees83510803sign_ees
slanders94014023slanders
smolders11287193smolders
soddens9348413s_oddens
soddies92312853s_oddies
soirees72411643s_oirees
solders83517773s_olders
sonde64622833s_ond_e_
sonder73623523s_ond_er
sones55444143s_on__es
sonless72612613s_onless
sonnets74211993s_onnets
sonnies7315223s_onnies
sooners73916643soon_ers
sounders93214123sounders
spaders104214473sp_aders
spades94222583sp_ad_es
spahees1238263sp_ahees
spaldeen1142773spaldeen
spaldeens1241793spaldeens
spancels1245273spancels
spandex1735833spand_ex
spandrel1144063spandrel
spandrels1243253spandrels
spangles1138893spangles
spaniels1045963spaniels
spankers14369863spankers
spanless10247363spanless
spanners103710773spanners
speeders11339313speeders
spencers12269193spencers
spences113413923spen_ces
spender103713693spend_er
spendier1147143spendier
spendiest1237533spendiest
spends94714473spend__s
spenses92913573spen_ses
spiders103914413sp_iders
spinages11289293spinages
spindle103210093spindle_
spindled12287643spindled
spindler11297983spindler
spindlers12286453spindlers
spinels94512443spin_els
spines85132033spin__es
spinets94714813spin_ets
spinless10238703spinless
spinners103810863spinners
spinneys13335553spinneys
spinnies103210543spinnies
spinules10249333spinules
splodges1234153splodges
spode84617703spo_d_e_
spoilers10238633spoilers
spokes124417213spo__kes
spondaic1343013spondaic
spondaics1442203spondaics
sponge939663spon_ge_
sponged1137953spon_ged
sponger1038523spon_ger
spongier1135743spongier
spongiest1237093spongiest
spongins1136563spongins
sponsons1045813sponsons
sponsors1045753sponsors
spoofers13307323spoofers
spoolers10349363spoolers
spooneys13314583spooneys
spoonies101911753spoonies
spores84726613spo__res
sporters103714063sporters
sporules1037703sporules
spotless1037043spotless
spotters104313383spotters
spouses92912813spo_uses
spouters104011163spouters
sprees85620643sp__rees
spudders12255633spudders
spunkies14227593spunkies
standee83514513standee_
standers93514303standers
stodges9309083sto_dges
stoners74817963ston_ers
stones65130033ston__es
sundaes8313093s_undaes
sunders84120063s_unders
sundews11398153s_undews
swindles12319503swindles
syndeses1245263s_yndeses
syndets1136113s_yndets
vendees114011453_vendees
wonders113315993_wonders

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.453394461.4
2DLD Change Limit1461621578.06318127.5
3Display Results1571570.0602616.7
 (SQL Overall)1786911578.57620836.2
 
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.