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 “whoofed” 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
whoofed1737451(None) 
hoofed134614891_hoofed
whooped16326931whooped
woofed134511201w_oofed
goofed114911382_goofed
hooded114616742_hooded
hoofer124014952_hoofer
hooked145320552_hooked
hooped125518182_hooped
hooted104422662_hooted
hooved134713122_hooved
proofed13138722proofed
roofed105214742_roofed
shooed103916082shoo_ed
shooled115212662shooled
spoofed13399102spoofed
wharfed1734412wharfed
whiffed2064472whiffed
whomped18345472whomped
whoof144612692whoof__
whoofs15457242whoof_s
whoopee15287512whoopee
whooper15297152whooper
whooshed1833452whooshed
whopped18358002whopped
whored135512122wh_ored
whorled14366902whorled
wolfed13428012w_olfed
wooded114213682w_ooded
wooed94419872w_oo_ed
woofer124411362w_oofer
wooled103715502w_ooled
behooved1743133behooved
blooded11379803blooded
bloomed12439433bloomed
blooped12398543blooped
boffed15369483_boffed
boobed114514873_boobed
booed85127273_boo_ed
booked135319503_booked
boomed115318133_boomed
booted94822733_booted
boozed184813833_boozed
brooded113510933brooded
brooked143610033brooked
broomed124111053broomed
chafed154813913ch_afed
chaffed19387703chaffed
chefed155010563ch_efed
cheffed19335863cheffed
chocked194411613chocked
choired13349343choired
choked164914793ch_oked
chomped17329773chomped
choose115116143choose_
chooser124412973chooser
chooses125717423chooses
choosey15459233choosey
chopped174511003chopped
chorded144710553chorded
chored125321883ch_ored
choused135012463choused
chowed154914653ch_owed
chowsed16478613chowsed
chromed153510923chromed
chuffed19316643chuffed
coifed124113063_coifed
cooed84534343_coo_ed
cooeed95917863_cooeed
cooked135921363_cooked
cooled95224593_cooled
cooped114821603_cooped
crooked143910943crooked
crooned103813343crooned
doffed14428503_doffed
doomed104113293_doomed
drooled9369203drooled
drooped11368433drooped
feoffed1332813feoffed
flooded12307933flooded
floored11268683floored
fooled104317823_fooled
footed104418623_footed
ghosted1236273ghosted
gloomed11337413gloomed
golfed11569763_golfed
goosed86817033_goosed
groomed11379503groomed
grooved12347253grooved
hoaxed17378873_hoaxed
hobbed144114303_hobbed
hoboed124511683_hoboed
hocked165521303_hocked
hoed87837983_h_o_ed
hogged125817773_hogged
hoised105117433_hoised
hoked135326993_h_oked
holed95634133_h_oled
holked144913663_holked
homed115425423_h_omed
honed95332263_h_oned
honied104818393_honied
honked144517913_honked
honored11310123_honored
hood85132333_hoo__d
hooey114926603_hoo_ey
hoof106036583_hoof__
hoofers134513323_hoofers
hoofs115721043_hoof_s
hooker134820173_hooker
hookey164713933_hookey
hooper114518313_hooper
hooter94123933_hooter
hoover124314433_hoover
hooves124815483_hooves
hoped115628183_h_oped
hopped144318113_hopped
horded115420483_horded
horned105718703_horned
horsed105321083_horsed
hosed95830983_h_osed
hosted105020343_hosted
hotbed123310683_hotbed
hotted104319943_hotted
housed105624103_housed
howked177312343_howked
howled134014973_howled
huffed163710153_huffed
loafed104011153_loafed
looed64626133_loo_ed
looked114717073_looked
loomed94616763_loomed
looped95217173_looped
loosed75520893_loosed
looted74421113_looted
mooed85123983_moo_ed
mooned94216643_mooned
moored93814173_moored
mooted94120373_mooted
noosed75018013_noosed
offed12359163__offed
oohed94214213__oohed
oozed154214263__oozed
phoned124014553ph_oned
phonied133710563phonied
phooey14379233phoo_ey
photoed1338913photoed
pooed85226243_poo_ed
poohed123912523_poohed
pooled94619813_pooled
pooped113915943_pooped
poufed12449713_poufed
proofer12149103proofer
reroofed1235873reroofed
rolfed104510523_rolfed
roofer94415283_roofer
rooked114918143_rooked
roomed95218543_roomed
roosed75621593_roosed
rooted75424003_rooted
schooled1447053schooled
scoffed16266183scoffed
scooped124611743scooped
scooted103612283scooted
sheafed14388973sheafed
shmoozed23254363shmoozed
shoaled113810973shoaled
shocked174611813shocked
shoed95723013sh_o_ed
shogged13397963shogged
shoofly1634353shoofly
shooter103013993shooter
shopped153512213shopped
shored105723653sh_ored
shorted113614403shorted
shotted113912403shotted
shouted113911553shouted
shoved134214283sh_oved
showed135016973sh_owed
shroffed1842563shroffed
snooded94110363snooded
snooked123711493snooked
snooled84513943snooled
snooped103711813snooped
snooted84213283snooted
snoozed173410133snoozed
sooted73922593_sooted
spoofer12368723spoofer
spooked144510473spooked
spooled104613523spooled
spooned103412443spooned
spoored104411293spoored
stooged94310733stooged
stooked124312303stooked
stooled84313893stooled
stooped103813833stooped
swooned11368593swooned
swooped13418753swooped
tholed105113873th_oled
thonged12376843thonged
thorned11479403thorned
thoued10429003th_oued
throned115412173throned
tooled74918903_tooled
tooted74620123_tooted
trooped104010723trooped
unhooded13277873unhooded
unhooked16286743unhooked
unroofed12106773unroofed
vroomed13366433vroomed
waffed16459793w_affed
wagoned1256223wagoned
waifed134011033w_aifed
webfed1535033w_ebfed
whacked20458623whacked
whaled134612033wh_aled
whammed18345133whammed
whanged15447613whanged
whapped18367573whapped
wheeled14318463wheeled
wheeped16387503wheeped
wheezed23296453wheezed
whelmed16375153whelmed
whelped16355633whelped
whetted14256693whetted
whidded1634423whidded
whiffer19105323whiffer
whiffet1965343whiffet
whiffled2133043whiffled
whiled134514133wh_iled
whined134715203wh_ined
whinged15409153whinged
whipped18379333whipped
whirled14368043whirled
whirred14386933whirred
whished17428023whished
whisked18336913whisked
whisted144010013whisted
whited134814083wh_ited
whizzed2234063whizzed
whoever1634103whoever
whole114418093wh_ole_
wholes124616773wh_oles
whoofing18234833whoofing
whoop134211443whoo__p
whoopees16294823whoopees
whoopers16286263whoopers
whoopie15295933whoopie
whoopies16267373whoopies
whoopla1542633whoopla
whoops14487863whoo_ps
whoosh15244353whoo_sh
whooshes1734423whooshes
whoosis1335453whoosis
whopper17328503whopper
whore116018043wh_ore_
whores125617103wh_ores
whose114914533wh_ose_
whumped18335633whumped
whupped18365413whupped
widowed1534843widowed
wifed125117743w__ifed
woaded115211603w_oaded
wolfer12429983w_olfer
wombed14419233w_ombed
wonned104012063w_onned
wonted103213283w_onted
wood85329383w_oo__d
wooden103610303w_ooden
wooer84316693w_oo_er
woof106532423w_oof__
woofers133810583w_oofers
woofs114918003w_oof_s
woolen93111373w_oolen
wooler93615873w_ooler
woolled1136643woolled
woopsed1344733woopsed
wooshed14167403wooshed
worded114316623w_orded
worked145314703w_orked
wormed124314303w_ormed
wotted104115713w_otted
wowed124023773w__owed
wronged12397673wronged
zoomed183610363_zoomed
zooned164011083_zooned

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.390458182.1
2DLD Change Limit1340272865.78323176.0
3Display Results2862860.0933075.3
 (SQL Overall)1786912866.26628517.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.