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

286 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
sprucer1131768(None) 
spruce103910871spruce_
spruced12307531spruced
spruces113810501spruces
sprucier1254791sprucier
pricer103918292_pricer
pruner83413452_pruner
saucer84314102s_aucer
seducer1056502seducer
spacer104917792sp_acer
spencer113610972spencer
spicer104719312sp_icer
splicer114710522splicer
spouter94213222spouter
sprayer12369042sprayer
sprier84119062spr_ier
sprucely1543122sprucely
sprucest12295782sprucest
sprucy13356322spruc_y
sprue74717632spru_e_
sprues84515762spru_es
spryer11418532spr_yer
spurner9269652spurner
spurrer93710222spurrer
spurter94013002spurter
adducer1184163adducer
bracer104620583_bracer
coruler9311713coruler
cruces105117543_cruces
cruder95612383_cruder
espouser1044383espouser
farcer115016083far_cer
forcer114917343for_cer
grocer94212143_grocer
inducer10318763inducer
mercer105214203mer_cer
pacer96131613_p_acer
pauper103511943_pauper
pauser84415963_pauser
peruser93511373peruser
piecer105213083_piecer
pincer104019173_pincer
placer105117743_placer
plucker15368243_plucker
pouncer113511233_pouncer
pourer84516043_pourer
pouter83923983_pouter
prancer113613383_prancer
prater84825353_prater
prayer114815293_prayer
prefer113813203_prefer
preyer114413733_preyer
price93725413_price_
priced115018883_priced
pricers113915063_pricers
prices104524543_prices
pricey134412633_pricey
pricier113313113_pricier
pricker154013413_pricker
prier75027763_pr_ier
primer105118683_primer
prizer174714883_prizer
prober104516073_prober
producer1355843_producer
proper104319953_proper
proser84223463_proser
prouder10310383_prouder
prover113819723_prover
prower114218123_prower
prude84615973_prude_
prudery1335243_prudery
prudes94215443_prudes
prune75119633_prune_
pruned93413113_pruned
pruners93710723_pruners
prunes83419063_prunes
pryer104415313_pr_yer
puce85127883_p_uce_
puces94924633_p_uces
pucker143817633_p_ucker
puler74826623_p_uler
purer75127903_p_urer
purger94717233_purger
purser85020473_purser
racer75233023__racer
reducer1059003reducer
ricer74726613__ricer
ruder65320543__ruder
ruer46127563__ru_er
ruler54923343__ruler
saluter73512453saluter
sapsucker1742123sapsucker
sarkier113413313sarkier
sauce75121653s_auce_
sauced93913303s_auced
saucers93712133s_aucers
sauces84919503s_auces
saucier9810283s_aucier
sauger74316253s_auger
scarcer113911373scarcer
scauper11379453scauper
scourer93910433scourer
scouter93313323scouter
scraper114513423scraper
screwer124410073screwer
scriber113910973scriber
scrubber1434123scrubber
securer958253securer
seduce9610023seduce_
seduced1186753seduced
seducers1145383seducers
seduces1069283seduces
serener73415763serener
serer55935513ser__er
serger73819743ser_ger
server94917713ser_ver
servicer1335263servicer
shouter103213083shouter
shriver134712193shriver
shucker163710103s_hucker
siruped1036013siruped
sirupier1034303sirupier
slicer84117603s_licer
sloucher13206813sloucher
soccer1038543s_occer
solacer93011103solacer
sorcery1237033sor_cery
sorer56236593sor__er
sorner64720393sor_ner
sorrier72313733sorrier
sorter64425093sor_ter
soucar839323s_oucar
source8410673source_
sourced1038453sourced
sources9312173sources
sourer63620213s_ourer
souter64225923s_outer
space95325673sp_ace_
spaced114517253sp_aced
spacers113813873sp_acers
spaces104722633sp_aces
spacey136212533sp_acey
spacier114011633spacier
spader94317133sp_ader
spaller92713473spaller
spammer133410433spammer
spancel1147363spancel
spanker133612353spanker
spanner94312563spanner
sparer84524963sp_arer
sparger103613083sparger
sparker133914363sparker
sparkier14298033sparkier
sparkler14317983sparkler
sparrier10329143sparrier
sparser94311483sparser
spatter94016523spatter
spawner12347363spawner
speaker133311213speaker
spearer93913663spearer
specced14266703specced
specter113111733specter
speeder103811073speeder
speer74623903sp__eer
speller95415143speller
spelter94113703spelter
spence103813793spence_
spencers12269193spencers
spences113413923spences
spender103713693spender
spewer115112153sp_ewer
spice95528813sp_ice_
spiced115218313sp_iced
spicers113815553sp_icers
spicery14499013sp_icery
spices104326033sp_ices
spicey134414233sp_icey
spicier115112463spicier
spider94516803sp_ider
spieler93111233spieler
spier75728033sp__ier
spiker124315663sp_iker
spikier13369983spikier
spiller92914333spiller
spinier93715163spinier
spinner93912263spinner
spirier93214073spirier
spitter94015183spitter
splice104915103splice_
spliced124310593spliced
splicers12338113splicers
splices113914383splices
splurger1143813splurger
splutter10357443splutter
spoiler93310683spoiler
sponger1038523sponger
spoofer12368723spoofer
spooler93711383spooler
sporter93616553sporter
sportier102010053sportier
sporular1065223sporular
sporule937273sporule_
sporules1037703sporules
spotter94514883spotter
spouse84112513spouse_
spoused10349653spoused
spouses92912813spouses
spouted103412263spouted
spouters104011163spouters
sprawler1334653sprawler
sprayed13398903sprayed
sprayers13367053sprayers
spreader1137483spreader
spree74830863spr__ee
sprees85620643spr_ees
sprigger12366503sprigger
springer113311753springer
sprinter103810813sprinter
sprite84421773sprite_
sprites94220333sprites
spritzer1944563spritzer
sprocket1646773sprocket
sprouted1136393sprouted
spruciest1345143spruciest
sprucing1336893sprucing
sprug85313893spru__g
sprugs94010173spru_gs
sprung94610033spru_ng
spudder11256553spudder
spue66025523sp_u_e_
spued84918473sp_u_ed
spues75025383sp_u_es
spume95817313sp_ume_
spumed114711543sp_umed
spumes1021314883sp_umes
spumier1137903spumier
spur65321193sp_u__r
spurge93711323spurge_
spurges104111653spurges
spurned10339263spurned
spurners10288493spurners
spurred103610623spurred
spurrers10338463spurrers
spurrey12307813spurrey
spurrier10297693spurrier
spurted103111973spurted
spurters103311703spurters
sputter94014053sputter
stouter74012053stouter
strafer103912463strafer
strayer104312503strayer
strewer104310413strewer
stricter1039423stricter
strider84315723strider
striker113714173striker
striper94514793striper
striver104315203striver
stroker114113523stroker
stroyer103510783stroyer
struck12489263struc_k
strucken1444323strucken
strudel835783strudel
strummer1234783strummer
strutter846503strutter
suber74924503s__uber
sucker124120663s__ucker
sucre75019103s__ucre
suer45334033s__u_er
super74924483s__uper
supremer1246483supremer
surer54833103s__urer
surfacer1345663surfacer
surfer93515883sur_fer
surfier102613543surfier
surger74320093sur_ger
surlier72915443surlier
syruped1334543syruped
syrupier1343053syrupier
tracer84820233_tracer
truce75118693_truce_
truced95312053_truced
truces84916333_truces
trucker134010733_trucker
truer54916643_tru_er
upriser9218763upriser
upriver12196933upriver

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272866.73619897.1
3Display Results2862860.1102600.0
 (SQL Overall)1786912867.25224640.2
 
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.