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

246 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
goodby1340628(None) 
goodbye14364191goodbye
goodbys14354171goodbys
goodly11419301goodly
goody105620391good_y
booby125319512boo_by
boody115420402bood_y
doody105517912dood_y
globby1434682globby
goby106021082g_o_by
godly104913292g_odly
good66531802good__
goodbyes15333502goodbyes
goodie83613992goodie
goods75124482good_s
gooey95522862goo_ey
goofy124915622goo_fy
googly11417882googly
gooky135818032goo_ky
goombay1543552goombay
gooney106612312gooney
goony95519782goo_ny
goopy115816622goo_py
goosey105913512goosey
goosy96018882goo_sy
grody103412062grod_y
hoody124919722hood_y
looby108115622loo_by
moody115017492mood_y
woodsy13505922woodsy
woody125116882wood_y
bloody124710173blood_y
blowby16467513blowby
bobby114814663_bobby
body107425673_bod_y
boldly12399423boldly
boob85932583boo_b_
boobs96221993boo_bs
boodle93215033boodle
boogey124711523boogey
boogy114518323boo_gy
boomy125421823boo_my
booty106125913boo_ty
boozy194917063boo_zy
broody124510083brood_y
cloddy13405233cloddy
cobby145516413_cobby
colby124415063_colby
coldly12459953coldly
cooey105828223coo_ey
cookey155414333cookey
cooky145321363coo_ky
coolly114811393coolly
cooly105525423coo_ly
coomb115615703coomb_
coombe124110093coombe
coombs124210193coombs
corby125018533_corby
corody12149703corod_y
dobby136013633_dobby
doby106022163_do_by
dodgy116611463_dodgy
doodad936423doodad
doodle83212853doodle
doodoo8108893doodoo
dooly94821803doo_ly
doomy116018263doo_my
doozy186813713doo_zy
dowdy136112543dowd_y
fondly13299043fondly
food86830573food__
foodie104413843foodie
foods95924163food_s
footboy1544913footboy
footsy12587933footsy
footy115820533foo_ty
forby135317673_forby
foreby1438633foreby
gabby135512953g_abby
gaby107123193g__aby
gaudy106611463gaud_y
geode7412593geod_e
geodes8412153geodes
geodesy1233133geodesy
geodic1048003geodic
ghosty13467213ghosty
giddy115810203g_iddy
gladly11497933gladly
glady105413943glad_y
glob76623393glo_b_
globe84917013glo_be
globs85616403glo_bs
gloomy12528763gloomy
gloppy1454723gloppy
glory96413293glo_ry
glossy10549003glossy
goad66830983goad__
goaded94913713goaded
goads77022853goad_s
gob68950893g_o_b_
gobo76126903g_o_bo
gobony1236913gobony
gobs76935573g_o_bs
god57449793g_od__
goddam1145163goddam
godded104811803godded
godet7530043g_odet
godown1136033godown
gods65438043g_od_s
goggly12337053goggly
gold65430163gold__
goldbug1242103goldbug
golden84411153golden
golder84417603golder
goldeye1234643goldeye
golds75421313gold_s
golly95121103g_olly
gombo105814043g_ombo
goo47754773goo___
goober93911743goober
goodies93516993goodies
goodish1237963goodish
goodman1135933goodman
goodmen1135623goodmen
goof85436873goo__f
goofed114911383goofed
goofily14105353goofily
goofs94821003goo_fs
googol835843googol
gooier73516213gooier
gook96429603goo__k
gooks105422883goo_ks
goombah1543113goombah
goombays1642823goombays
goon57236173goo__n
gooneys11407073gooneys
goonie73615563goonie
goons65326773goo_ns
goop75829483goo__p
goops86620963goo_ps
gooral7310463gooral
goos57644913goo__s
goose65925903goo_se
goosed86817033goosed
gooses75723053gooses
gorily10612503gorily
gorsy95915783g_orsy
gory86129663g_o_ry
gouty95217363g_outy
gowany13457493gowany
gowd96519983gowd__
gowds105814043gowd_s
goy77844553g_o__y
grabby14336183grabby
groggy1234803groggy
groovy13375403groovy
groszy19395703groszy
grotty10389833grotty
grouty104710983grouty
growly13499173growly
grubby14324503grubby
hobby155913733_hobby
hood85132333hood__
hooded114616743hooded
hoodie105116143hoodie
hoodoo10109983hoodoo
hoods95124083hood_s
hooey114926603hoo_ey
hookey164713933hookey
hooky155220263hoo_ky
hooly115022223hoo_ly
hooray123011373hooray
hooty115022443hoo_ty
howdy155711413howd_y
knobby1732713knobby
koodoo11107773koodoo
kooky114412873koo_ky
lobby125113923_lobby
looey84822913loo_ey
looney94712413looney
loony86918963loo_ny
loopy105316643loo_py
lordly1038753lordly
loudly1037783loudly
moldy115014653mold_y
monody1238243monod_y
mood76332063mood__
moodily1358203moodily
moods85224623mood_s
mooley11311633mooley
moony104818273moo_ny
moory105115793moo_ry
nobby125513463_nobby
nobody1235743nobod_y
noddy105411203_noddy
noodge8337583noodge
noodle73212543noodle
nooky124814813noo_ky
noonday1144603noonday
oddly1037163_oddly
oldy85316843_old_y
oozy167018133_oo_zy
orby97519603__orby
outby10411533_outby
podgy125610773_podgy
pood75934323pood__
poodle93112043poodle
poods85124753pood_s
poofy136213273poo_fy
poorly1137893poorly
rood56733003rood__
roods65125283rood_s
rooky126117623roo_ky
roomy107118063roo_my
rooty86423023roo_ty
rowdy125711533rowd_y
shoddy1434543shoddy
slobby1334803slobby
snobby1334403snobby
soddy104210703_soddy
sodomy1276673sodomy
sooey84522433soo_ey
sooty84924843soo_ty
stodgy11415733stodgy
toady96814343toad_y
toby96322293_to_by
today96416953_today
toddy106812423_toddy
tody86327213_tod_y
toothy12529693toothy
tootsy9437983tootsy
voodoo10127533voodoo
womby155910093_womby
wood85329383wood__
woodbin1354873woodbin
woodbox2043693woodbox
wooded114213683wooded
wooden103610303wooden
woodie103513613woodie
woods95723033wood_s
woolly12408513woolly
wooly114417673woo_ly
woozy204410603woo_zy
wordy126916163word_y
zooey173914803zoo_ey
zooty175415353zoo_ty

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.376475242.0
2DLD Change Limit1127162465.37320978.2
3Display Results2462460.0803075.0
 (SQL Overall)1786912465.82930655.5
 
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.