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

234 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
sprucy1335632(None) 
spruce103910871spruce
pricy124814562_pricy
saucy104615162s_aucy
sirupy11377052sirupy
spacy125415622sp_acy
spicy125417712sp_icy
spray106720062spr_ay
spruced12307532spruced
sprucely1543122sprucely
sprucer11317682sprucer
spruces113810502spruces
sprue74717632spru_e
sprues84515762sprues
sprug85313892spru_g
sprugs94010172sprugs
sprung94610032sprung
spry96819122spr__y
spryly1435512spryly
spumy124610362sp_umy
spurry11429122spurry
struck12489262struck
syrupy14285822syrupy
cruck135615323_cruck
curacy1339593curacy
eruct74022353_eruct
farcy135217093far_cy
koruny1334443koruny
mercy125916183mer_cy
osprey1134883ospr_ey
pacy115328683_p_acy
piracy1339473piracy
pluck134212303_pluck
plucky17406583_plucky
plumy124213233_plumy
pouch124617083_pouch
pouchy16538663_pouchy
pouty107018813_pouty
pray96331533_pr_ay
prexy174611583_prexy
prey96228483_pr_ey
price93725413_price
pricey134412633_pricey
prick134317503_prick
pricky174210343_pricky
privy13439833_privy
prosy106319253_prosy
proxy175011013_proxy
prude84615973_prude
prune75119633_prune
pruta7314243_pruta
pry85728053_pr__y
puce85127883_p_uce
puck124927943_p_uck
puny95526993_p_uny
pursy105016413_pursy
purty105019403_purty
racy95825683__racy
ruby97819943__ruby
ruck104728333__ruck
ruly76323143__ruly
sarky125521783sar_ky
sauce75121653s_auce
sauch104918773s_auch
saury84317223s_aury
screwy14659463screwy
scrub94914203scru_b
scrubby1642803scrubby
scrubs104210313scrubs
scruff1437963scruff
scruffy1842643scruffy
scrum95418203scru_m
scrums104614253scrums
scrunch1444033scrunch
scrunchy1852383scrunchy
scry96017763scr__y
scurfy14338763scurfy
scurry11419593scurry
scurvy14386103scurvy
secrecy1444743secrecy
seduce9610023seduce
serac75925203serac_
seracs84418573seracs
serry84824123ser_ry
serum75223473seru_m
serums83916303serums
sheuch14267043sheuch
shmuck1734243shmuck
shrub104814893shru_b
shrubby1742363shrubby
shrubs11409213shrubs
shrug94512513shru_g
shrugs10469163shrugs
shrunk13357063shrunk
shuck144314533s_huck
sirup74014913siru_p
sirups83710533sirups
slouch11438523slouch
slouchy15454843slouchy
sluicy1166483sluicy
slurry9378603slurry
snouty9419953snouty
snuck114411913s_nuck
sorely94618013sorely
sorry84618253sor_ry
sorus54527583soru_s
soupy106115403s_oupy
source8410673source
sourly93612213sourly
space95325673sp_ace
spacey136212533spacey
sparely123410673sparely
sparkly16348133sparkly
sparky154511523sparky
sparry115111303sparry
spay96631663sp__ay
spec85821973sp_ec_
speck135115653sp_eck
specs96916673sp_ecs
speech1347563speech
speedy1218410793speedy
spence103813793spence
spendy124911143spendy
sphery14318883sphery
spic85227433sp_ic_
spica94717943sp_ica
spice95528813sp_ice
spicey134414233spicey
spick134519073sp_ick
spics94123243sp_ics
spiffy17326223spiffy
spikey155411333spikey
spiky146014113sp_iky
spinny114510183spinny
spiny104921303sp_iny
spirula9257703spirula
spiry105017353sp_iry
spivvy1733213spivvy
splay105816043sp_lay
splice104915103splice
splurgy1343023splurgy
spongy1236743spongy
spoofy14498553spoofy
spooky15418093spooky
spoony114111793spoony
sporty115112493sporty
sporule937273sporule
spotty11448583spotty
spouse84112513spouse
spout75029633spou_t
spouts85115113spouts
sprag86418693spr_ag
sprags95715823sprags
sprain83614863sprain
sprang95713523sprang
sprat76635973spr_at
sprats85819933sprats
sprawl11188063sprawl
sprawly15166043sprawly
sprays115913643sprays
spread9312533spread
spree74830863spr_ee
sprees85620643sprees
sprent84522383sprent
sprier84119063sprier
sprig85617743spr_ig
spriggy14374213spriggy
sprigs94814773sprigs
spring94526013spring
springy13359663springy
sprint84526793sprint
sprit76736403spr_it
sprite84421773sprite
sprits85122533sprits
spritz174714423spritz
sprout8419403sprout
sprouts949983sprouts
sprucest12295783sprucest
sprucier1254793sprucier
sprucing1336893sprucing
spryer11418533spryer
spud75818493sp_u_d
spuds85113673sp_uds
spue66025523sp_u_e
spued84918473sp_ued
spues75025383sp_ues
spume95817313sp_ume
spun66221463sp_u_n
spunk114513403sp_unk
spunky15427163spunky
spur65321193sp_u_r
spurge93711323spurge
spurn74815453sp_urn
spurns84811383spurns
spurrey12307813spurrey
spurs74621523sp_urs
spurt77227983sp_urt
spurts84814973spurts
sputa74612963sp_uta
spy86023743sp___y
stoury9529943stoury
strawy1210312823strawy
stray88525573str_ay
strick124813203strick
strict84821043strict
stripy115812743stripy
stroy87720393str_oy
strum75619453stru_m
struma84313273struma
strums84716453strums
strung75213023strung
strunt64918913strunt
strut56030733stru_t
struts65616803struts
stuck114515773s_tuck
study94411793s_tudy
sturdy1037043sturdy
such96424813s__uch
suck106131733s__uck
sucky144415503s__ucky
surely93816463surely
surety93515013surety
surfy115319473sur_fy
surgy95118523sur_gy
surly85124433sur_ly
surrey94414583surrey
survey124111673survey
syrup103010963syru_p
syrups11277953syrups
truce75118693_truce
truck116115463_truck
truly84111553_truly
unruly938083unruly
uprush1135783uprush

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162344.79623502.1
3Display Results2342340.0763078.9
 (SQL Overall)1786912345.26233958.8
 
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.