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

398 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
spruces11381050(None) 
spruce103910871spruce_
spruced12307531spruced
sprucer11317681sprucer
sprucest12295781sprucest
sprues84515761spru_es
cruces105117542_cruces
prices104524542_prices
prudes94215442_prudes
prunes83419062_prunes
puces94924632_p_uces
sauces84919502s_auces
seduces1069282seduces
sources9312172sources
spaces104722632sp_aces
spences113413922spences
spices104326032sp_ices
splices113914382splices
sporules1037702sporules
spouses92912812spouses
sprees85620642spr_ees
sprites94220332sprites
sprucely1543122sprucely
sprucier1254792sprucier
spruciest1345142spruciest
sprucy13356322spruc_y
sprue74717632spru_e_
sprugs94010172spru_gs
spues75025382sp_u_es
spumes1021314882sp_umes
spurges104111652spurges
truces84916332_truces
abduces1286243abduces
adduces1185763adduces
almuces11316823almuces
apices104916263ap_ices
apres75426403apr__es
boraces113716853boraces
braces108427773_braces
brumes106417073_brumes
brutes86118683_brutes
bruxes154811023_bruxes
caprices1439893caprices
carices114220953carices
ceruses93716233ceruses
crucks144412583_crucks
crudes96218623_crudes
cruses88127713_cruses
cruxes154911563_cruxes
cypruses1534313cypruses
deduces1168793deduces
deuces94015513_deuces
drupes94912653_drupes
druses75517253_druses
duces86327473__duces
educes94011953_educes
eructs83610793_eructs
espouses1037303espouses
estruses838483estruses
farces115223323far_ces
fauces114916153_fauces
ferules103112723ferules
forces114422133for_ces
graces94523493_graces
grues65721963_gru_es
grumes94415553_grumes
hyraces1537913hyraces
induces103611813induces
luces75528433__luces
merces105720743mer_ces
misprices1547913misprices
murices112612283murices
opuses84012243op_uses
orrices9129363orrices
paces96741113_p_aces
parures9512693parures
pauses84621473_pauses
peaces106324083_peaces
perukes133210113perukes
peruses94018163peruses
pieces104217273_pieces
places104323703_places
plucks14379733_plucks
plumes104318133_plumes
pluses83618073_pluses
ponces104720843_ponces
pouches144116743_pouches
pounces114113893_pounces
prances113618773_prances
prases84429023_prases
prates84633163_prates
praxes156215183_praxes
precess11310863_precess
precis103416703_precis
prees75937173_pr_ees
prepuces1438583_prepuces
prexes154915943_prexes
prezes173614693_prezes
price93725413_price_
priced115018883_priced
pricer103918293_pricer
pricers113915063_pricers
pricey134412633_pricey
pricks144414263_pricks
prides94324183_prides
pries74339533_pr_ies
primes104225263_primes
princes113015143_princes
prises84133173_prises
prizes173819813_prizes
probes104119453_probes
process11310403_process
produces1347903_produces
proles84627203_proles
proses84733473_proses
proves114322253_proves
prude84615973_prude_
prune75119633_prune_
pruned93413113_pruned
pruner83413453_pruner
pruners93710723_pruners
prunus8399363_prunus
pubes94423403_p_ubes
puce85127883_p_uce_
pucks134322103_p_ucks
pukes114523023_p_ukes
pules74538813_p_ules
purees84721683_purees
purges94421763_purges
purses84826373_purses
puses75532203_p_uses
races74943243__races
reduces10513343reduces
reprices122913353reprices
rices75536153__rices
rubes74928413__rubes
ruches114819583__ruches
rucks114422053__rucks
rues46044483__ru_es
rules55234253__rules
runes55530223__runes
ruses56136583__ruses
saices84221803s_aices
salutes73716253salutes
saprobes1237033saprobes
sarapes94617743sarapes
sarees65329943sar_ees
sarges75128593sar_ges
sarodes84216143sarodes
saroses73619333saroses
sauce75121653s_auce_
sauced93913303s_auced
saucer84314103s_aucer
saucers93712133s_aucers
sauchs115112233s_auchs
sauries72821623sauries
sautes63924913s_autes
sconces113811453sconces
scouses93313243scouses
scrapes116217663scrapes
screes85023963scr_ees
scribes113713203scribes
scries85226823scr_ies
scrives124414273scrives
scrouges1136683scrouges
scrubs104210313scru_bs
scruffs1554173scruffs
scrums104614253scru_ms
scrunches1635403scrunches
scruples1237433scruples
scutes85219193s_cutes
seances93015343seances
secures9613163secures
seduce9610023seduce_
seduced1186753seduced
seducer1056503seducer
seducers1145383seducers
segues7412073segu_es
seracs84418573serac_s
serapes95218103serapes
serenes73222903serenes
seres55448893ser__es
serges74225963ser_ges
series64540973ser_ies
serines74229543serines
serries73925353serries
serums83916303seru_ms
serves94423653ser_ves
services1338573services
sheuchs15234933sheuchs
shmucks1833943shmucks
shrikes144412393shrikes
shrines104618693shrines
shrives134416173shrives
shrubs11409213shru_bs
shrugs10469163shru_gs
shucks154010413s_hucks
shutes93518223s_hutes
sices75637273s__ices
sinuses73011593sinuses
sirees64624583sir_ees
sires55945373sir__es
sirrees73410573sirrees
siruped1036013siruped
sirups83710533siru_ps
situses72710493situses
slices84022853s_lices
slouches13208073slouches
slues54527173s_lu_es
sluices959073sluices
solaces93116133solaces
solutes73515263solutes
sores55454283sor__es
sorites73825243sorites
soroches1338803soroches
soroses73117483soroses
sorties74126403sorties
sorus54527583soru__s
source8410673source_
sourced1038453sourced
souses64229243s_ouses
soyuzes1932953soyuzes
space95325673sp_ace_
spaced114517253sp_aced
spacer104917793sp_acer
spacers113813873sp_acers
spacey136212533sp_acey
spades94222583sp_ades
spadices1336093spadices
spaes76029973sp__aes
spahees1238263spahees
spales84728103sp_ales
spancel1147363spancel
spancels1245273spancels
spares84834553sp_ares
sparges104016343sparges
sparkles143210493sparkles
spates85028173sp_ates
spathes125116533spathes
spavies123012943spavies
spazzes1735263spazzes
specced14266703specced
species11314133species
specks144312703sp_ecks
specs96916673sp_ec_s
speeches1537413speeches
speises93813933speises
spence103813793spence_
spencer113610973spencer
spencers12269193spencers
spenses92913573spenses
sphenes123013163sphenes
spheres123114353spheres
spherules1443823spherules
spicas104715823sp_icas
spice95528813sp_ice_
spiced115218313sp_iced
spicer104719313sp_icer
spicers113815553sp_icers
spicey134414233sp_icey
spicks144814993sp_icks
spics94123243sp_ic_s
spicules12219803spicules
spies76037623sp__ies
spikes124520713sp_ikes
spiles84227913sp_iles
spines85132033sp_ines
spinules10249333spinules
spiracles1345663spiracles
spiremes12397623spiremes
spires84628113sp_ires
spirulas10207203spirulas
spites84127333sp_ites
spitzes1849183spitzes
splakes1349673splakes
splice104915103splice_
spliced124310593spliced
splicer114710523splicer
splicers12338113splicers
splines94718893splines
splores91910953splores
splurges1145163splurges
spodes94817433sp_odes
spokes124417213sp_okes
sponges10311043sponges
spores84726613sp_ores
sporule937273sporule_
spouse84112513spouse_
spoused10349653spoused
spouted103412263spouted
spouter94213223spouter
spouters104011163spouters
spouts85115113spou_ts
sprags95715823spr_ags
sprains93013593sprains
sprangs104610053sprangs
sprats85819933spr_ats
sprawls12176373sprawls
sprayed13398903sprayed
sprayer12369043sprayer
sprayers13367053sprayers
sprays115913643spr_ays
spreads1039763spreads
spree74830863spr__ee
sprier84119063spr_ier
spriest92718643spr_iest
sprigs94814773spr_igs
springes114014033springes
springs104415923springs
sprints94113773sprints
sprite84421773sprite_
sprits85122533spr_its
spritzes1946943spritzes
sprocket1646773sprocket
sprockets1743253sprockets
sprouted1136393sprouted
sprouts949983sprouts
spruceness1444103spruceness
sprucing1336893sprucing
sprug85313893spru__g
sprung94610033spru_ng
spryer11418533spr_yer
spryest12247813spr_yest
spryness1334003spryness
spuds85113673sp_u_ds
spue66025523sp_u_e_
spued84918473sp_u_ed
spume95817313sp_ume_
spumed114711543sp_umed
spunks12349333sp_unks
spurge93711323spurge_
spurned10339263spurned
spurner9269653spurner
spurners10288493spurners
spurns84811383sp_urns
spurred103610623spurred
spurrer93710223spurrer
spurrers10338463spurrers
spurrey12307813spurrey
spurreys13364603spurreys
spurries102311323spurries
spurs74621523sp_u_rs
spurted103111973spurted
spurter94013003spurter
spurters103311703spurters
spurtles1037783spurtles
spurts84814973sp_urts
stances93715963stances
stoures74614163stoures
strafes104516003strafes
strakes114218073strakes
stricks134310693stricks
strides84520393strides
strifes104716583strifes
strikes114719093strikes
stripes95320573stripes
strives104119373strives
strobes93813263strobes
strokes114316323strokes
struck12489263struc_k
strucken1444323strucken
strudel835783strudel
strudels934123strudels
strumas9419833strumas
strums84716453stru_ms
strunts7429543strunts
struts65616803stru_ts
stupes84116953s_tupes
subduces1397263subduces
subraces12313033subraces
subrules1039723subrules
sucks114523073s__ucks
sucres84218893s__ucres
sues46247653s__u_es
supes75628303s__upes
supremes1238363supremes
surfaces1338673surfaces
surges73924593sur_ges
sutures7314223sutures
syces106416463s__yces
syruped1334543syruped
syrups11277953syru_ps
terces83921413ter_ces
traces85329933_traces
trices84826333_trices
truce75118693_truce_
truced95312053_truced
trucks124711973_trucks
trues54925323_tru_es
uprates93814863uprates
uprises92012733uprises
uprouses1037553uprouses
uprushes13194863uprushes
uruses63616503_uruses
varices123313573varices
varuses10310623varuses
viruses1039413viruses
xeruses143010753xeruses

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340273986.03322215.6
3Display Results3983980.1402842.9
 (SQL Overall)1786913986.32628247.1
 
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.