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

260 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
sodomy127667(None) 
sodom8814911sodom_
sodoms989671sodoms
boomy125421822bo_omy
bosomy13509032bosomy
doomy116018262do_omy
isonomy1245262isonomy
ostomy1137832ostomy
roomy107118062ro_omy
soddy104210702sod_dy
sooey84522432so_oey
sooty84924842so_oty
anomy105113393_anomy
atomy107415193_atomy
bionomy1444723bionomy
bloomy134510113bloomy
bodily12310993bodily
body107425673bod__y
booby125319513bo_oby
boody115420403bo_ody
boogy114518323bo_ogy
boom87435673bo_om_
booms95427123bo_oms
booty106125913bo_oty
boozy194917063bo_ozy
bosom95516923bosom_
bosoms104913053bosoms
broomy13449953broomy
chromy16309903chromy
codify1537163codify
codon86522853codo_n
codons96119463codons
colony115417273colony
commy144712643co_mmy
condom114215363condom_
condoms124214083condoms
cooey105828223co_oey
cooky145321363co_oky
cooly105525423co_oly
coomb115615703co_omb
corody12149703corody
demy105422853__demy
doby106022163__doby
dodgy116611463dod_gy
dodo66024913dodo__
dodoes85716103dodoes
dodos75819393dodo_s
dogdom1186363dogdom_
dogdoms1295423dogdoms
dogy96126493__dogy
dom69752443__dom_
dome77240733__dome
doms76239573__doms
doody105517913do_ody
dooly94821803do_oly
doom76430073do_om_
dooms85321343do_oms
doozy186813713do_ozy
dopy106224153__dopy
dormy115817473do_rmy
dory85836233__dory
doty86128223__doty
doxy156419953__doxy
dozy175920323__dozy
economy1445433economy
foamy135313203fo_amy
footy115820533fo_oty
gloomy12528763gloomy
gobony1236913gobony
godly104913293god_ly
godown1136033godown
goodby13406283goodby
goodly11419303goodly
goody105620393go_ody
gooey95522863go_oey
goofy124915623go_ofy
gooky135818033go_oky
goony95519783go_ony
goopy115816623go_opy
goosy96018883go_osy
homy126623223__homy
hoody124919723ho_ody
hooey114926603ho_oey
hooky155220263ho_oky
hooly115022223ho_oly
hooty115022443ho_oty
iodous7311503iodous
isodose845373isodose
isogamy1343993isogamy
isogony11215453isogony
isotopy12215123isotopy
kooky114412873ko_oky
loamy105913343lo_amy
looby108115623lo_oby
looey84822913lo_oey
loom67035053lo_om_
looms75124643lo_oms
loony86918963lo_ony
loopy105316643lo_opy
lordoma1056043lordoma
modem103717143modem_
modems114610763modems
modify1537173modify
mommy114010753mo_mmy
monody1238243monody
moody115017493mo_ody
moony104818273mo_ony
moory105115793mo_ory
nobody1235743nobody
noddy105411203nod_dy
nodose738883nodose
nodous7711333nodous
nooky124814813no_oky
oddly1037163_oddly
odor55718093_odo_r
odors64514283_odors
odour64710493_odour
ology94113113_ology
oogamy1235633oogamy
oology103210253oology
oozy167018133_o_ozy
poboy121612223pobo_y
podgy125610773pod_gy
pommy14449863po_mmy
poofy136213273po_ofy
radome9511873radome
rooky126117623ro_oky
room66235083ro_om_
rooms75324683ro_oms
rooty86423023ro_oty
sadly94519123sad_ly
savory124310563savory
savoy114713883savo_y
saxony1636233saxony
scotoma1155963scotoma
scummy15265223scummy
seamy105921273s_eamy
sedgy104512793sed_gy
sedum84115573sedum_
sedums93910483sedums
seldom939413seldom_
seldomly1442393seldomly
sepoy10314303sepo_y
shadowy1744723shadowy
shammy16388503shammy
shamoy14379913shamoy
shimmy16306413shimmy
shoddy1434543shod_dy
sholom11910113sholom_
sholoms1278033sholoms
showy145714013s_howy
simony1137903simony
slimy105417423s_limy
slummy13325863slummy
smarmy13629353smarmy
smoky14388683s_moky
snoopy11449473snoopy
snooty94211513snooty
snoozy18517233snoozy
snowy115011563s_nowy
soapy106114783so_apy
sod46053703sod___
soda56329383sod__a
sodas64123543sod_as
sodded94113303sodded
sodden84011513sodden
sodic84917493sod_ic
sodium92111453sodium
sodiums10177213sodiums
sodomies11128553sodomies
sodomist1157633sodomist
sodomite11136913sodomite
sodomize20135253sodomize
sods54940213sod__s
softly12457763softly
softy115414483so_fty
soggy105413903so_ggy
sokol94612293soko_l
sokols10399093sokols
soldo67116563soldo__
solely93714213solely
solemn838643solemn
solo45538943solo__
soloed74515743soloed
solon55026133solo_n
solons65120023solons
solos54830793solo_s
solum74717613solum_
solums85211333solums
som59153813s__om_
soma65635293s__oma
some66040383s__ome
somoni8310743somoni
soms66239373s__oms
sonly85718053so_nly
sonny85016103so_nny
sonsy86416373so_nsy
sook84933393so_o_k
sooks94425453so_oks
soon46240503so_o_n
soot45761063so_o_t
sooth85924063so_oth
soots55536213so_ots
sophy136611763so_phy
sopor74016493sopo_r
sopors85215203sopors
soppy125113523so_ppy
sordor7310223sordo_r
sordors8310013sordors
sorely94618013sorely
sorry84618253so_rry
sotol54917653soto_l
sotols63714473sotols
soupy106115403so_upy
sourly93612213sourly
soy67851453s__o_y
spoofy14498553spoofy
spooky15418093spooky
spoony114111793spoony
spumy124610363s_pumy
steamy115112373steamy
stemmy13417033stemmy
stimy105114743s_timy
stodgy11415733stod_gy
stogy95414083s_togy
stoma75918273s_toma
stomp95616663s_tomp
stony85818643s_tony
stormy115510733stormy
story86723033s_tory
stroma84313073stroma
stroy87720393stro_y
stymy13358293s_tymy
sudary1038703sudary
sudor6312623sudo_r
sudors7311103sudors
sudsy95010683sud_sy
swamy136714403s_wamy
swimmy16234353swimmy
swoony12408263swoony
swoopy14487283swoopy
today96416953tod_ay
toddy106812423tod_dy
tody86327213tod__y
tommy124712233to_mmy
toom66532933to_om_
vasotomy1642673vasotomy
vodou939343vodo_u
vodoun1036233vodoun
vodous1038603vodous
woodsy13505923woodsy
woody125116883wo_ody
wooly114417673wo_oly
woozy204410603wo_ozy
wormy137514253wo_rmy
zooey173914803zo_oey
zoom156722103zo_om_
zooms164415523zo_oms
zootomy2154803zootomy
zooty175415353zo_oty

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.403443402.0
2DLD Change Limit1127162607.33015377.4
3Display Results2602600.0932795.7
 (SQL Overall)1786912607.82622833.0
 
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.