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

261 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
sprucing133689(None) 
pricing123417342_pricing
pruning10311732_pruning
saucing10311002s_aucing
seducing1236502seducing
siruping1136502siruping
sourcing1158352sourcing
spacing123614492sp_acing
speccing15306642speccing
spicing123914532sp_icing
splicing1338962splicing
spousing11198732spousing
spouting113511952spouting
spraying14299882spraying
spring94526012spr__ing
sprouting1236942sprouting
sprucier1254792sprucier
sprung94610032spru__ng
spuing94313362sp_u_ing
spuming1248522sp_uming
spurning11258662spurning
spurring11339762spurring
spurting113111632spurting
syruping1434252syruping
trucing103211842_trucing
abducing1474063abducing
adducing1384113adducing
aproning11311793aproning
arcing95819643_ar_cing
bracing123817613_bracing
brucin1049133_brucin_
brucine1138273_brucine
brucins1158003_brucins
bruting102612993_bruting
bruxing17236823_bruxing
deducing1336423deducing
deucing1139393_deucing
educing1137683_educing
eructing112110173_eructing
espousing1265003espousing
farcing133514003far_cing
feruling1258873feruling
forcing134013753for_cing
gracing113216443_gracing
inducing1237873inducing
mispricing1746713mispricing
pacing114522753_p_acing
pausing103912813_pausing
peacing124117073_peacing
perusing11811063perusing
piecing12410453_piecing
placing123815283_placing
plucking17357723_plucking
pluming123412043_pluming
poncing122913583_poncing
pouching163210413_pouching
pouncing13318883_pouncing
pouring103115863_pouring
pouting103519943_pouting
prancing132612163_prancing
prating103424453_prating
praying133717323_praying
preeing103817673_preeing
preying133114553_preying
pricking173212603_pricking
priding113317543_priding
priming123417373_priming
prising103321453_prising
prizing193514683_prizing
probing123314443_probing
producing1556143_producing
prosing103319383_prosing
proving134214073_proving
prying124114803_pr_ying
puking133913063_p_uking
puling93621403_p_uling
purging113314183_purging
purling103620293_purling
purring104515823_purring
pursing103715553_pursing
racing95030533__racing
reducing12310203reducing
repricing14310473repricing
ricing94822763__ricing
ruching133612933__ruching
rucking143216673__rucking
ruing67221053__ru_ing
ruling73219553__ruling
saluting9310553saluting
sarcina9310733sar_cina
sconcing1338263sconcing
scouring112810853scouring
scouting112612753scouting
scraping133310863scraping
screwing14288233screwing
scribing13238183scribing
scriving14258763scriving
scrouging1335263scrouging
scrubbing1633933scrubbing
scrumming1654023scrumming
scrunching18163473scrunching
scrupling1435193scrupling
scrutiny1344773scrutiny
scrying1338663scr_ying
securing11310413securing
segueing1034983segueing
serging93416673ser_ging
sericin9312843sericin_
sericins10312463sericins
sering74731813ser__ing
serrying12167703serrying
servicing1545343servicing
serving113014983ser_ving
shauling1249393shauling
shouting122711793shouting
shrewing15228093shrewing
shrining122610853shrining
shriving15268453shriving
shrouding1434753shrouding
shrugging1533703shrugging
shucking18339433s_hucking
shuting113212053s_huting
siccing12319513s_iccing
siring75128313sir__ing
slicing103514643s_licing
slouching15195723slouching
sluicing1137063sluicing
sluing74315883s_lu_ing
slurping11278123slurping
slurring9288833slurring
snouting92511923snouting
solacing11310133solacing
sorbing102815263sor_bing
soricine10710883soricine
soring74731883sor__ing
sorning83116813sor_ning
sorting83221813sor_ting
souping104215533s_ouping
souring83219063s_ouring
sousing83517823s_ousing
spacings13287043sp_acings
spading113114383sp_ading
spaeing103413543sp_aeing
spalling113213463spalling
spamming15317603spamming
spanking153911973spanking
spanning113311083spanning
sparging122611133sparging
sparing104823873sp_aring
sparking152812543sparking
sparkling16226353sparkling
sparling112714533sparling
sparring113112223sparring
spasming13227203spasming
spatting113111763spatting
spawning14296913spawning
spaying133014623sp_aying
speaking153212493speaking
speaning113512243speaning
spearing113216103spearing
specking17359733specking
speeding122810933speeding
speeling112713123speeling
speering113116323speering
speiling113612973speiling
speiring113711263speiring
spelling113315233spelling
spending122712433spending
spewing133110453sp_ewing
sphering142811943sphering
spieling113212523spieling
spiering112713353spiering
spiffing17237083spiffing
spiking144312883sp_iking
spiling102919703sp_iling
spilling113113943spilling
spinning113310813spinning
spiraling1237953spiraling
spiring103918183sp_iring
spiriting1238413spiriting
spirting112913633spirting
spirulina1143423spirulina
spiting103917623sp_iting
spitting113012323spitting
splaying14219303splaying
splining11310773splining
splurging1333623splurging
spoiling112911553spoiling
spoking143212223sp_oking
sponging1238823sponging
spoofing14228363spoofing
spooking15269803spooking
spooling113212563spooling
spooning112811443spooning
spooring113111463spooring
sporing104319413sp_oring
sporting112415463sporting
spotting112812093spotting
spoutings12245153spoutings
sprain83614863spr_ain_
spraining1248153spraining
sprains93013593spr_ains
sprang95713523spr__ang
sprawling15175123sprawling
spreading1339653spreading
sprig85617743spr__i_g
sprigging1435893sprigging
springe103913983spr__inge
springing1338743springing
springs104415923spr__ings
springy13359663spr__ingy
sprint84526793spr__int
sprinting12310033sprinting
spritzing2135393spritzing
spruce103910873spruc__e
spruced12307533spruc_ed
sprucely1543123sprucely
sprucer11317683spruc_er
spruces113810503spruc_es
sprucest12295783sprucest
spruciest1345153spruciest
sprucy13356323spruc__y
sprug85313893spru___g
spudding1335653spudding
spunking15258063spunking
spying123913253sp__ying
strafing122111193strafing
strawing122411623strawing
straying122912693straying
strewing12289853strewing
striding102713603striding
striking133012233striking
string75327563str__ing
striping112612523striping
striving122611393striving
stroking132610943stroking
strouding1136373strouding
strowing122310563strowing
stroying122410593stroying
strumming1454413strumming
strung75213023stru__ng
strunting1037873strunting
strutting1037003strutting
subducing1544573subducing
sucking143217413s__ucking
suing65026363s__u_ing
surfacing1545643surfacing
surfing112914483sur_fing
surging93115433sur_ging
suturing9310373suturing
swouning12246563swouning
syncing13177223s_yncing
tracing103720153_tracing
tricing103417353_tricing
trucking153310163_trucking
trueing83410183_trueing
truing73913933_tru_ing
uprating11311113uprating
uprising1138953uprising
uprousing1235623uprousing
uprushing1544043uprushing

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 Filter1786911461620.403443402.0
2DLD Change Limit1461622616.90621164.5
3Display Results2612610.1102372.7
 (SQL Overall)1786912617.41924085.6
 
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.