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

132 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
seconders123695(None) 
seconder1137181seconder_
secondes1138131seconde_s
decoders122810412deco_ders
reconfers1437212reconfers
recorders12187952recorders
scolders11288992s_colders
scowders14276232s_cowders
seceders11277962sec_eders
secondary1543192secondary
seconde1037412seconde__
seconded1236352seconde_d
seconds1038282second__s
senders83022352se__nders
sonders83820712s__onders
absconders1542373absconders
accorders14144123accorders
ascenders1235683ascenders
beckoners1744063beckon_ers
beholders1544933beholders
benders104021063be__nders
bonders104120663__bonders
cinders104617763__cinders
codders114114453__codders
coders95426983__co_ders
condors104018573__condors
confers124120093__confers
congers104223233__congers
conkers133721043__conkers
conners94023113__conners
corders104520883__corders
deboners11268113debon_ers
decanters12229223decanters
decenters122410373decenters
deciders123510753dec_iders
decoder113712293deco_der_
decodes113914983deco_de_s
decoyers14287713deco_yers
defenders1436363defenders
degenders1236083degenders
demanders13247573demanders
descenders1445453descenders
emenders11319033_emenders
encoders1137513enco_ders
enders74324053_e__nders
fenders113717263fe__nders
genders93616783ge__nders
lenders84419643le__nders
meanders1168833me_anders
menders103818803me__nders
ponders103618843__ponders
rebounders1343933rebounders
recanters112310483recanters
reckoners1545113reckon_ers
recodes102918633reco_de_s
recoilers11318153recoilers
recondense1345503recondense
reconfer1337673reconfer_
reconquers2193353reconquers
reconsiders1443183reconsiders
reconvert1449473reconvert
reconverts1545723reconverts
reconveys1743533reconveys
recorder11249633recorder_
recounters1246213recounters
recovers133511123reco_vers
refunders1334973refunders
rejoinders1843123rejoinders
reloaders1036423reloaders
reminders12308653reminders
renders83821673re__nders
reorders9198833re_orders
rescinders1344303rescinders
resolders10258013resolders
responders1345773responders
rewinders13246503rewinders
sanders84025943s__anders
scanners10379703s_canners
scoffers16286133s_coffers
scolder103210343s_colder_
sconces113811453s_conce_s
scones84521303s_con_e_s
scoopers124210193s_coopers
scooters103511033s_cooters
scorers94115323s_co_rers
scorners10228493s_corners
scoters93313813s_co_ters
scourers10348533s_courers
scouters103411323s_couters
scowder13286873s_cowder_
scowlers13257373s_cowlers
scunners10357303s_cunners
seasoners946263season_ers
seceder10329573sec_eder_
secedes103711983sec_ede_s
secludes1134953seclude_s
seconals1047053secon_als
second9411153second___
secondaries1454043secondaries
secondi1044943second__i
seconding1337613seconding
secondly1443663second_ly
secondo1044933second__o
securers1057153sec_urers
seders74420283se___ders
seeders83017113se__eders
seiners74219273se_in_ers
sender73824413se__nder_
serenaders11204663serenaders
slanders94014013s_landers
smolders11287193s_molders
solanders1036963solanders
solders83517773s__olders
sonder73623523s__onder_
sondes74922873s__onde_s
sooners73916643s_oon_ers
sounders93214113s_ounders
spenders113211743s_penders
spondees1136483s_pondees
spongers1137603s_pongers
squanders1934443squanders
standers93514303s_tanders
stoners74817953s_ton_ers
stranders10389933stranders
suborders1245503suborders
sunders84120053s__unders
swooners11336863swoon_ers
tenders83719723te__nders
tenoners858713tenon_ers
venders113717003ve__nders
vocoders1434243voco_ders
wonders113315993__wonders

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411327.26620457.1
3Display Results1321320.0602200.0
 (SQL Overall)1786911327.74923059.9
 
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.