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

347 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
spencers1226919(None) 
spencer113610971spencer_
spences113413921spence_s
spenders113211741spenders
fencers123810622_fencers
openers9339492open_ers
pencels113610052_pencels
penners93414182_penners
pincers113916502_pincers
senders83022352s_enders
silencers1145282silencers
spacers113813872sp_acers
spancels1245272spancels
spankers14369862spankers
spanners103710772spanners
speakers14299452speakers
spearers103711142spearers
specters122811062specters
speeders11339312speeders
speers85019952spe__ers
spellers102812762spellers
spelters103912242spelters
spence103813792spence__
spender103713692spender_
spenses92913572spense_s
spewers124210662spe_wers
spicers113815552sp_icers
spinners103810862spinners
splicers12338112splicers
spongers1137602spongers
amenders11288353amenders
amercers1256133amercers
ascenders1235683ascenders
aspersers11377243aspersers
assenters966993assenters
avengers1235583avengers
benchers153611013_benchers
benders104021063_benders
blenchers16356723blenchers
blenders115210993blenders
bouncers12309353bouncers
cancers114018583_cancers
censers94313903_censers
centers94420603_centers
chancers154313493chancers
clenchers16276553clenchers
coercers1237653coercers
dancers103413093_dancers
deicers103612733_deicers
deniers84515183_deniers
dispensers13146743dispensers
drenchers15296103drenchers
emenders11319033emenders
enders74324053__enders
enters64425643__enters
essences1047563essence_s
eveners10109503even_ers
expenders19145963expenders
fencer114613533_fencer_
fences114617113_fence_s
fenders113717263_fenders
fleecers13325933fleecers
flensers1135463flensers
genders93616783_genders
glancers11408003glancers
keeners113610783keen_ers
lancers93616643_lancers
lenders84419643_lenders
licencers13134643licencers
menacers12279313_menacers
menders103818803_menders
mercers114412773_mercers
mincers113714853_mincers
opener83910993open_er_
openness1035473openness
pacers105124543_p_acers
panders103423733_panders
paniers94717333_paniers
panners93621273_panners
panzers184012013_panzers
peaces106324083_peace_s
peachers153213843_peachers
peckers153312673_peckers
pedlers103013273_pedlers
peelers93615593_peelers
peepers113713673_peepers
peers75130273_pe__ers
pelters93720313_pelters
pence94924453_pence__
pencel103812913_pence_l
pencilers1345643_pencilers
pencils113011773_pencils
penes75839223_pen_e_s
penner84616663_penner_
pensees9311203_pensees
pensters103012123_pensters
peppers103311443_peppers
perchers153611523_perchers
pesters93827093_pesters
peters86624593_pe_ters
petters93722363_petters
pewters124113353_pewters
piecers114112253_piecers
piercers12316723piercers
pincer104019173_pincer_
pinchers153510613_pinchers
pinders103720473_pinders
pingers104020743_pingers
pinkers134118603_pinkers
pinners93518603_pinners
placers114515263_placers
ponces104720843_ponce_s
ponders103618843_ponders
pouncers12349203pouncers
prancers123210333prancers
pricers113915063_pricers
punchers152610073_punchers
punkers133714853_punkers
punners94114233_punners
punters93617043_punters
quenchers2343173quenchers
reenters82915303reenters
renders83821673_renders
renters74224813_renters
repenters112511553repenters
ripeners1036833ripen_ers
sanders84025943s_anders
sangers84421943s_angers
sapiences13116423sapience_s
saucers93712133s_aucers
saunters82911753saunters
scanners10379703scanners
scenery1236563scen_ery
scenes84520353scen_e_s
scepters1237793scepters
sciences1238773science_s
sconces113811453sconce_s
scunners10357303scunners
sealers74323553s_ealers
seamers94719433s_eamers
seances93015343seance_s
seaters74028943s_eaters
secern81010223s_e_cern
secerns987733s_e_cerns
seders74420283s_e_ders
seducers1145383seducers
seeders83017113s_eeders
seekers113712333s_eekers
seemers93814333s_eemers
seers55136383s_e__ers
seiners74219273s_einers
seisers73816393s_eisers
seizers164112503s_eizers
sellers73721323s_ellers
sender73824413s_ender_
senecas939013s_enecas
senhors103512133s_enhors
seniors73413623s_eniors
sennets73712583s_ennets
senores73218113s_enores
senors63620793s_en_ors
senseis73310643s_enseis
senses63923943s_ense_s
sensors73514643s_ensors
sentencers1274783sentencers
sequencers2143093sequencers
sergers83815633s_ergers
servers103214833s_ervers
setters73822063s_etters
severs94121123s_e_vers
sewers94719723s_e_wers
shearers113911323shearers
shedders13267433shedders
sheers94322403she__ers
sheeters113111863sheeters
shellers112812583shellers
shelters113412813shelters
shelvers14388813shelvers
shewers134312053she_wers
shiners104015943shin_ers
shunners11317743shunners
shunters113210753shunters
signers84714443sign_ers
silencer1036293silencer_
silences10310073silence_s
sincere9310553s_incere
singers83824703s_ingers
sinkers113618543s_inkers
sinners74019023s_inners
sinters74024083s_inters
sixpences2043633sixpence_s
skankers11316483skankers
skeeters12298963skeeters
skelters12349373skelters
skenes104616633sken_e_s
sketchers1834513sketchers
skewers14498383ske_wers
skinkers11298183skinkers
skinners12347293skinners
slanders94014013slanders
sledders10257373sledders
sleekers12377993sleekers
sleepers103110113sleepers
slender83413593slender_
slicers94114923s_licers
slingers93712683slingers
smearers10308623smearers
smellers10329773smellers
smelters103310513smelters
sneakers12308643sneakers
sneerers8309803sneerers
sneers64016173s__neers
sneezers17246143sneezers
soccers1138393s_occers
solacers10268893solacers
sonders83820713s_onders
sooners73916643soon_ers
sorners73416873sorn_ers
sounders93214113sounders
spacer104917793sp_acer_
spaces104722633sp_ace_s
spaders104214473sp_aders
spallers102910733spallers
spammers14378693spammers
spancel1147363spance_l
spaniels1045963spaniels
spanker133612353spanker_
spanless10247363spanless
spanner94312563spanner_
sparers94519613sp_arers
spargers11389733spargers
sparkers144111313sparkers
spatters103914703spatters
spawners13396493spawners
speaker133311213speaker_
spearer93913663spearer_
spears84019473spe__ars
specced14266703specce_d
species11314133spe_cies
specks144312703spe_c_ks
specs96916673spe_c__s
specter113111733specter_
spectra11275833spe_ctra
spectre11297773spe_ctre
spectres12268683spe_ctres
speeches1537413speeches
speeder103811073speeder_
speeds94316053spe__eds
speels85116393spe__els
speer74623903spe__er_
speirs85013233spe__irs
speises93813933speise_s
speller95415153speller_
spelter94113703spelter_
spelunkers1641763spelunkers
spendier1147143spendier_
spends94714473spen__ds
spense83912433spense__
spewer115112153spe_wer_
sphenes123013163sphen_e_s
sphincters1742073sphincters
spicer104719313sp_icer_
spicery14499013sp_icery
spices104326033sp_ice_s
spiders103914413sp_iders
spielers10319653spielers
spiers84421743sp__iers
spikers135311993sp_ikers
spillers103311703spillers
spindlers12286453spindlers
spinels94512443spin_els
spines85132033spin_e_s
spinets94714813spin_ets
spinier93715163spinier_
spinless10238703spinless
spinner93912263spinner_
spinnery13416593spinnery
spinneys13335553spinneys
spinors939423spin_ors
spinsters1136613spinsters
spitters104113383spitters
splendors1244023splendors
splicer114710523splicer_
splices113914383splice_s
splinters11277923splinters
spoilers10238633spoilers
spondees1136483spondees
sponger1038523sponger_
sponges10311043sponge_s
sponsors1045753sponsors
spoofers13307323spoofers
spoolers10349363spoolers
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
sprayers13367053sprayers
spreaders1236503spreaders
springers12309983springers
sprinters11329363sprinters
sprucer11317683sprucer_
spruces113810503spruce_s
spudders12255633spudders
spurners10288493spurners
spurrers10338463spurrers
spurters103311703spurters
sputters104012873sputters
stances93715963stance_s
stanchers14206813stanchers
standers93514303standers
stealers83412213stealers
steamers103410873steamers
steepers103011373steepers
steerers82511353steerers
steers63820983ste__ers
stemmers12378443stemmers
stenches132110293stenches
stencilers1243003stencilers
stencils1046403stencils
stentors839743stentors
steppers12289283steppers
stingers94012743stingers
stinkers123111133stinkers
stinters83312753stinters
stoners74817953ston_ers
stunners8277923stunners
sunders84120053s_unders
supercars13410143supercars
suspenders1384583suspenders
suspensers12114323suspensers
swearers11328583swearers
sweaters113811063sweaters
sweepers13348163sweepers
swelters113110193swelters
swervers1455213swervers
swingers123710423swingers
teeners74415453teen_ers
tenders83719723_tenders
tenners74014923_tenners
tenters73921103_tenters
trenchers14288073trenchers
venders113717003_venders
veneers103710293_veneers
venters103717733_venters
wenchers16319213_wenchers
wieners103212483wien_ers
wincers123415363_wincers
wrenchers17256333wrenchers

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 Filter1786911461620.406440125.6
2DLD Change Limit1461623476.40622816.4
3Display Results3473470.1402478.6
 (SQL Overall)1786913476.95225703.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.