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

227 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
nobody123574(None) 
nonbody1344821nonbody
anybody1642572anybody
body107425672__body
boody115420402bo_ody
corody12149702corody
doody105517912do_ody
embody1435032embody
gobony1236912gobony
goody105620392go_ody
hoody124919722ho_ody
imbody1434112imbody
monody1238242monody
moody115017492mo_ody
nobby125513462nob_by
nobly105314402nob_ly
noddy105411202no_ddy
nooky124814812no_oky
poboy121612222pobo_y
rebody1238152rebody
unibody1343352unibody
woody125116882wo_ody
abode85518813_abode
antibody1445343antibody
bloody124710173bloody
bobby114814663bob_by
bod67055543__bod_
bode75838753__bode
bods76244713__bods
bogy106426193__bogy
bony96732083__bony
booby125319513bo_oby
boogy114518323bo_ogy
boomy125421823bo_omy
booty106125913bo_oty
boozy194917063bo_ozy
bosomy13509033bosomy
boxy166420733__boxy
boy87753563__bo_y
broody124510083broody
cobby145516413cob_by
coembody1842493coembody
colony115417273colony
comedy14378233comedy
cooey105828223co_oey
cooky145321363co_oky
cooly105525423co_oly
corrody13136143corrody
cowboy1637063cowbo_y
dipody1336363dipody
dobby136013633dob_by
doby106022163dob__y
dogsbody1641463dogsbody
dooly94821803do_oly
doomy116018263do_omy
doozy186813713do_ozy
dowdy136112543do_wdy
ebony104511513_ebony
emboly1336723emboly
enology11239813enology
food86830573fo_od_
foods95924163fo_ods
footy115820533fo_oty
forbode13257963forbode
forebody1745153forebody
gobo76126903gobo__
goboes95914443goboes
gobos86219383gobo_s
goby106021083gob__y
good66531803go_od_
goodby13406283go_odby
goodly11419303go_odly
goods75124483go_ods
gooey95522863go_oey
goofy124915623go_ofy
gooky135818033go_oky
goony95519783go_ony
goopy115816623go_opy
goosy96018883go_osy
grody103412063_grody
hobby155913733hob_by
hobo97026083hobo__
hoboed124511683hoboed
hoboes114717443hoboes
hobos106321353hobo_s
homebody1954053homebody
hood85132333ho_od_
hoods95124083ho_ods
hooey114926603ho_oey
hooky155220263ho_oky
hooly115022223ho_oly
hooty115022443ho_oty
howdy155711413ho_wdy
knobbly1842873knobbly
knobby1732713knob_by
kobo107422103kobo__
kobold1365963kobold
kobolds1474343kobolds
kobos115616893kobo_s
kooky114412873ko_oky
lobby125113923lob_by
lobed86022133lobed_
lobo67229863lobo__
lobos75921843lobo_s
looby108115623lo_oby
looey84822913lo_oey
loony86918963lo_ony
loopy105316643lo_opy
lowboy1435903lowbo_y
melody1237203melody
moldy115014653mo_ldy
monopody1645493monopody
mood76332063mo_od_
moods85224623mo_ods
moony104818273mo_ony
moory105115793mo_ory
mouldy12437413mouldy
nabob93913743nabo_b
nabobs10388213nabobs
nebuly1135793nebuly
neddy10479873n_eddy
needy94614693n_eedy
neology11238293neology
nerdy95014703n_erdy
niobous936333niobous
nob58954423nob___
nobbily1436693nobbily
nobble103814313nobble
noble74420993nob_le
nobler83713453nobler
nobles83319723nobles
nobodies1137293nobodies
nobs66436903nob__s
nod47549563n__od_
node513036883n__ode
nodi56626743n__odi
nodose738883nodose
nodous7711333nodous
nods55838223n__ods
nohow1137293noho_w
noily86120993no_ily
noisy86813363no_isy
nolo46229313nolo__
nolos54423353nolo_s
nomad86016183nomad_
nomads94711603nomads
nomoi76012533nomo_i
nomos75919743nomo_s
nonbook1346283nonbook
nongay10169153nongay
nonoily1049543nonoily
nonwoody1544273nonwoody
noo37154043no_o__
noodge8337583no_odge
noodle73212543no_odle
nook85728493no_o_k
nooks95420393no_oks
noon47134623no_o_n
noonday1144603noonday
noons54125283no_ons
noose55624063no_ose
nosed65524553nosed_
nosey85619883no_sey
nosily93712683nosily
nosy76322893n__osy
notary92310713notary
noted65123843noted_
notedly1136883notedly
notify1236943notify
noway111112843no_way
noyade1036423noyade
nubbly13369673nubbly
nubby125011033nub_by
obey96521303_ob_ey
oboe66822943_obo_e
oboes75717713_oboes
obol65220613_obo_l
obole75917143_obole
oboli73712873_oboli
obols73715863_obols
oldy85316843_o_ldy
ology94113113_ology
oniony9369703oniony
oology103210253oology
oozy167018133_o_ozy
parody12410093parody
poboys1397313poboys
pood75934323po_od_
poods85124753po_ods
poofy136213273po_ofy
potboy1397813potbo_y
prosody1336433prosody
robed85323733robed_
robot7325973robo_t
robotry1244173robotry
robots8313153robots
rood56733003ro_od_
roods65125283ro_ods
rooky126117623ro_oky
roomy107118063ro_omy
rooty86423023ro_oty
rowdy125711533ro_wdy
snobby1334403snob_by
snood64616163sno_od_
snoods74312453sno_ods
snoopy11449473sno_opy
snooty94211513sno_oty
snoozy18517233sno_ozy
soddy104210703so_ddy
sodomy1276673sodomy
somebody1642923somebody
sooey84522433so_oey
sooty84924843so_oty
toady96814343to_ady
toby96322293tob__y
toddy106812423to_ddy
tody86327213__tody
tomboy1358213tombo_y
wobbly16347093wobbly
wood85329383wo_od_
woods95723033wo_ods
woodsy13505923wo_odsy
wooly114417673wo_oly
woozy204410603wo_ozy
wordy126916163wo_rdy
zooey173914803zo_oey
zooty175415353zo_oty

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.373479064.3
2DLD Change Limit1127162275.51620434.4
3Display Results2272270.0603783.3
 (SQL Overall)1786912275.94930037.1
 
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.