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

349 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
spoofy1449855(None) 
poofy136213271_poofy
spoof105019011spoof_
spoofs114011811spoofs
spooky15418091spooky
spoony114111791spoony
goofy124915622_goofy
poof95541662_poof_
poofs105222792_poofs
shoofly1634352shoofly
snoopy11449472snoopy
snooty94211512snooty
snoozy18517232snoozy
sooey84522432s_ooey
sooty84924842s_ooty
spiffy17326222spiffy
spongy1236742spongy
spoofed13399102spoofed
spoofer12368722spoofer
spoofery16354312spoofery
spook115416042spoo_k
spooks124312932spooks
spool75219042spoo_l
spools85115912spools
spoon74719442spoo_n
spooney12418242spooney
spoons84116022spoons
spoor75016352spoo_r
spoors84014032spoors
sporty115112492sporty
spotty11448582spotty
swoony12408262swoony
swoopy14487282swoopy
aloof83521573aloof_
aloofly1343623aloofly
apology1337913apology
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
booby125319513_booby
boody115420403_boody
boogy114518323_boogy
boomy125421823_boomy
booty106125913_booty
boozy194917063_boozy
broody124510083broody
broomy13449953broomy
choosy14459103choosy
comfy153710213_comfy
cooey105828223_cooey
coof96643273_coof_
coofs105924713_coofs
cooky145321363_cooky
cooly105525423_cooly
dhooly13457143dhooly
doody105517913_doody
dooly94821803_dooly
doomy116018263_doomy
doozy186813713_doozy
drooly104911073drooly
droopy12458243droopy
epoxy17465773ep_oxy
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
footy115820533_footy
gloomy12528763gloomy
goody105620393_goody
gooey95522863_gooey
goof85436873_goof_
goofs94821003_goofs
gooky135818033_gooky
goony95519783_goony
goopy115816623_goopy
goosy96018883_goosy
groovy13375403groovy
hoody124919723_hoody
hooey114926603_hooey
hoof106036583_hoof_
hoofs115721043_hoofs
hooky155220263_hooky
hooly115022223_hooly
hooty115022443_hooty
kloof123812133kloof_
kloofs13386353kloofs
kooky114412873_kooky
looby108115623_looby
looey84822913_looey
loof78141053_loof_
loofa85912813_loofa
loofs85623783_loofs
loony86918963_loony
loopy105316643_loopy
moody115017493_moody
moony104818273_moony
moory105115793_moory
nooky124814813_nooky
oozy167018133__oozy
peony105717563_peony
phony136715443_phony
phooey14379233phooey
ploy96123603_plo_y
poboy121612223_poboy
pocky165314603_pocky
podgy125610773_podgy
poesy105014063_poesy
pogey116017893_pogey
pogy105623553_p_ogy
pokey145318973_pokey
poky135922153_p_oky
poly96235153_p_oly
pommy14449863_pommy
pony96434053_p_ony
poo57757113_poo__
pooch124815303_pooch
pood75934323_poo_d
poods85124753_poods
pooed85226243_pooed
pooh96027383_poo_h
poohs103915713_poohs
pool65835953_poo_l
pools74427703_pools
poon67341263_poo_n
poons75430973_poons
poop86532813_poo_p
poops94422413_poops
poor65630223_poo_r
poori74816233_poori
poorly1137893_poorly
poos65949113_poo_s
poove104514303_poove
poppy114813193_poppy
popsy125713403_popsy
porgy116916123_porgy
porky145019333_porky
porny106020193_porny
posy96028423_p_osy
potsy105815613_potsy
potty105621003_potty
pouf95732643_pouf_
pouff135215423_pouff
pouffy17395883_pouffy
poufs105616063_poufs
pouty107018813_pouty
poxy166820893_p_oxy
prof96134663_prof_
profs105120893_profs
proof105221533proof_
proofs114511683proofs
prosy106319253_prosy
proxy175011013_proxy
ptooey11346413ptooey
puffy164410753_puffy
roof75738833_roof_
roofs85321153_roofs
rooky126117623_rooky
roomy107118063_roomy
rooty86423023_rooty
salify12311373salify
saponify1644183saponify
savory124310563savory
savoy114713883savo_y
saxony1636233saxony
scoff134413343s_coff
scoffs14347503scoffs
scooch13228123scooch
scoop95617163scoo_p
scoops105414363scoops
scoot75729153scoo_t
scoots85315943scoots
scorify1535203scorify
scurfy14338763scurfy
sepoy10314303sepo_y
setoff1238913setoff
shoaly124010773shoaly
shoddy1434543shoddy
shoo75929893shoo__
shooed103916083shooed
shook124920163shoo_k
shooks134515633shooks
shool84523153shoo_l
shools94919013shools
shoon84022013shoo_n
shoos84226363shoo_s
shoot84235913shoo_t
shoots94619363shoots
shorty124313203shorty
showoff1943893showoff
showy145714013s_howy
shroff1538503shroff
simony1137903simony
slobby1334803slobby
sloop76118913sloo_p
sloops85513623sloops
sloppy1395303sloppy
sloshy12366623sloshy
slowly1237153slowly
smoggy1354283smoggy
smokey15398653smokey
smoky14388683s_moky
smooch13266803smooch
smoochy17223863smoochy
smoosh11236733smoosh
smooth11259203smooth
smoothy15205083smoothy
sniffy15337193sniffy
snobby1334403snobby
snood64616163snoo_d
snoods74312453snoods
snook95115573snoo_k
snooks104412833snooks
snool55118643snoo_l
snools65715883snools
snoop75317173snoo_p
snoops84314173snoops
snoot55030143snoo_t
snoots64216683snoots
snooze15439993snooze
snotty9489203snotty
snouty9419953snouty
snowy115011563s_nowy
snuffy15356243snuffy
soapy106114783s_oapy
soddy104210703s_oddy
sodomy1276673sodomy
sofa75625603s__ofa
soft76942823s__oft
softy115414483s_ofty
soggy105413903s_oggy
sonly85718053s_only
sonny85016103s_onny
sonsy86416373s_onsy
sook84933393s_oo_k
sooks94425453s_ooks
soon46240503s_oo_n
soot45761063s_oo_t
sooth85924063s_ooth
soots55536213s_oots
sophy136611763s_ophy
sopor74016493sopo_r
sopors85215203sopors
soppy125113523s_oppy
sorry84618253s_orry
soupy106115403s_oupy
soy67851453s__o_y
spacey136212533spacey
spacy125415623sp_acy
sparky154511523sparky
sparry115111303sparry
spay96631663sp__ay
specify1764993specify
speedy1218410793speedy
spendy124911143spendy
sphery14318883sphery
spicey134414233spicey
spicy125417713sp_icy
spiff133616403sp_iff
spiffs14328473spiffs
spikey155411333spikey
spiky146014113sp_iky
spinny114510183spinny
spinoff1544933spinoff
spiny104921303sp_iny
spiry105017353sp_iry
spivvy1733213spivvy
splay105816043sp_lay
spliff1438603spliff
splore81611303splore
splosh1186543splosh
spode84617703sp_ode
spodes94817433spodes
spoil75818653sp_oil
spoils84614533spoils
spoilt85016593spoilt
spoke114818663sp_oke
spoked134413893spoked
spoken124610003spoken
spokes124417213spokes
sponge939663sponge
spoofers13307323spoofers
spoofing14228363spoofing
spooked144510473spooked
spookery17264143spookery
spookily1744173spookily
spooled104613523spooled
spooler93711383spooler
spooned103412443spooned
spooneys13314583spooneys
spoonful1343753spoonful
spoonily1335233spoonily
spoored104411293spoored
sporal82915453sporal
spore75428593sp_ore
spored94821793spored
spores84726613spores
sporoid102310733sporoid
sport75935983sp_ort
sports84619183sports
spot65540693sp_o_t
spots74424113sp_ots
spouse84112513spouse
spout75029633sp_out
spouts85115113spouts
spray106720063sp_ray
sprout8419403sprout
sprucy13356323sprucy
spry96819123sp__ry
spryly1435513spryly
spumy124610363sp_umy
spunky15427163spunky
spurry11429123spurry
spy86023743sp___y
stocky15369153stocky
stodgy11415733stodgy
stogey105811543stogey
stogy95414083s_togy
stoney96217353stoney
stony85818643s_tony
stood65517713stoo_d
stooge73811663stooge
stook95218213stoo_k
stooks105115373stooks
stool55619893stoo_l
stools65117023stools
stoop75821543stoo_p
stoops85917893stoops
stopoff1565023stopoff
storey95217613storey
stormy115510733stormy
story86723033s_tory
stoury9529943stoury
stroy87720393stro_y
stuffy15317083stuffy
surfy115319473s_urfy
swoon85014783swoo_n
swoons94511143swoons
swoop105213433swoo_p
swoops114910923swoops
swoosh12195213swoosh
toffy145310283_toffy
whoof144612693whoof_
whoofs15457243whoofs
woody125116883_woody
woof106532423_woof_
woofs114918003_woofs
wooly114417673_wooly
woozy204410603_woozy
zooey173914803_zooey
zooty175415353_zooty

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 Filter1786911127160.796224486.2
2DLD Change Limit1127163496.53317253.3
3Display Results3493490.1562237.2
 (SQL Overall)1786913497.48523873.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.