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

304 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
oogeny1011792(None) 
orogeny11107021orogeny
zoogeny2044361zoogeny
biogeny1336022biogeny
bogey115220232boge_y
boogey124711522booge_y
cogency1547012cogency
cogent9321002cogent
dogey105719512doge_y
fogey125617872foge_y
homogeny1745622homogeny
isogeny11196362isogeny
monogeny1446132monogeny
ontogeny1244792ontogeny
oogamy1235632oogamy
pogey116017892poge_y
progeny1389462progeny
agency1237033_agency
agene65621583_agene
agent65829643_agent
agony96415653_agony
argent74023663argent
augend837633augend
autogeny1245233autogeny
biogen9310253biogen_
biogens1038963biogens
bogan87519003bogan_
bogans95714813bogans
bogeys124510913bogeys
boggy126116073bog_gy
bogy106426193bog__y
boney105227313bone_y
bonny105816623bo_nny
bony96732083bo__ny
booger94816553booge_r
boogers104514633boogers
boogeys13476873boogeys
boogy114518323boog__y
bookend14396643bookend
bootery1238983bootery
botany1139263botany
bowery146012113bowery
cagey115917823cage_y
coagency1644863coagency
coagent10313983coagent
coden86128543coden_
codens94821013codens
cogently1446323cogently
cogon89120903cogon_
cogons96818113cogons
cogway1566183cogway
colony115417273colony
comedy14378233comedy
comely134213733comely
coney105932883cone_y
cony96537833co__ny
cooey105828223cooe_y
cookery164210393cookery
cookey155414333cooke_y
coopery143910273coopery
copen94826433copen_
copens106119963copens
corny106023273co_rny
cosey106226713cose_y
coven106925043coven_
covens114919263covens
covey136121783cove_y
cozen165019703cozen_
cozens176314923cozens
cozey196718543coze_y
cryogeny1743553cryogeny
cytogeny1744083cytogeny
deny86027123__deny
docent92918683docent
dodgery13627783dodgery
doge66233803doge__
dogear838193dogear
doges75630163doge_s
dogeys115510663dogeys
doggery13448263doggery
doggy115214873dog_gy
dogy96126493dog__y
dopey116020353dope_y
doven94718553doven_
dovens104413903dovens
dowery134311663dowery
downy125714553do_wny
doyen95014413doyen_
doyens104810223doyens
dozen155017473dozen_
dozens164612463dozens
endogeny1345433endogeny
eocene8311613eocene
exogen1436513exogen_
exogens1536883exogens
fogeys13509263fogeys
foggy136714543fog_gy
fogy115923183fog__y
foley115222303fole_y
foment113718303foment
foolery1336693foolery
foreby1438633foreby
forgery14419303forgery
gen45950513__gen_
gene56237223__gene
gens55740073__gens
gent56954393__gent
genu55929073__genu
gey75738303__ge_y
gobony1236913gobony
goggly12337053goggly
gooey95522863gooe_y
googly11417883goog_ly
gooney106612313goone_y
goony95519783go_ony
goosey105913513goose_y
gowany13457493gowany
greeny104811453greeny
hogan97817703hogan_
hogans105914313hogans
hogmenay1753883hogmenay
hokey155422183hoke_y
holey115626903hole_y
hologyny1843143hologyny
homely145313173homely
homey135924843home_y
hominy144511483hominy
homogony1745043homogony
honey115629913hone_y
hooey114926603hooe_y
hookey164713933hooke_y
horny115619623ho_rny
hosen85623883hosen_
hosey116127023hose_y
hugely1336803hugely
ionogen837123ionogen_
ionogens956823ionogens
isogony11215453isogony
joey145719333jo_e_y
johnny1932193johnny
jokey195014693joke_y
koruny1334443koruny
lagend838743lagend
legend837693legend
lineny94011443lineny
loden66621143loden_
lodens74315063lodens
logan68123283logan_
logans76319063logans
loge56837193loge__
loges66534203loge_s
loggy105714193log_gy
logily1039833logily
login66025003login_
logins77820643logins
logon615922313logon_
logons79818173logons
logway1335913logway
logy87025783log__y
loment84021473loment
lonely92912473lonely
looey84822913looe_y
looney94712413loone_y
loony86918963lo_ony
loosely1036713loosely
loosen66615963loosen_
loosens716310953loosens
lovely12339713lovely
lowery124112713lowery
lysogeny1543393lysogeny
moggy125212163mog_gy
moiety1148223moiety
moment103319683moment
money104826843mone_y
monogyny1743723monogyny
mony96830013mo__ny
mooley11311633moole_y
moony104818273mo_ony
mopery135210973mopery
mopey124821823mope_y
morgen9312203morgen_
morgens10310463morgens
mosey105922873mose_y
motey105922953mote_y
neogene847553neogene
neoteny1045023neoteny
nocent83217413nocent
nomen75621623nomen_
nosey85619883nose_y
novena936763novena
oaken95814383oaken_
oaten55222403oaten_
obey96521303_obe_y
ochery14319443ochery
offend13365663offend
often84611413often_
ogee57629883_oge_e
ogees65119143_ogees
olden65114853olden_
ology94113113olog__y
omen66828183_omen_
omens75618963_omens
oncogene1145953oncogene
onery8414123_onery
oniony9369703oniony
oogenies9311583oogenies
oogonia846483oogonia
oohed94214213oohe_d
oohing104412933oohing
oology103210253oology
oolong738073oolong
ooze136420603ooze__
oozed154214263ooze_d
oozes145418713ooze_s
oozily18328073oozily
oozing163812203oozing
oozy167018133oo__zy
open66427003_open_
openly1137123_openly
opens76118553_opens
organ6915393organ_
organa789213organa
organdy1254573organdy
organs7912913organs
orgeat7515033orgeat
orgone71110913orgone
orgy85218003org__y
orient6322533orient
ornery938463ornery
orogenic11109363orogenic
orrery936783orrery
oven76624143_oven_
ovens86217453_ovens
owsen84210193owsen_
oxen116218593_oxen_
oxygen1743313oxygen_
oxygens1843163oxygens
poesy105014063po_esy
pogeys124110353pogeys
pogy105623553pog__y
pokey145318973poke_y
poleyn1157323poleyn
ponent82821593ponent
pony96434053po__ny
popery134511703popery
porny106020193po_rny
potency1457433potency
potent84223353potent
redeny102712733redeny
regency1337363regency
regent74127673regent
rodent7519243rodent
roger64521413roge_r
rogers74517913rogers
roguery1134893roguery
rookery14398313rookery
ropery114313873ropery
ropey106021873rope_y
rosery93813283rosery
rosiny94414533rosiny
rouen54920903rouen_
rouens64814443rouens
roven85521973roven_
rowen84921153rowen_
rowens94515303rowens
sagely102811383sagely
sheeny124912193sheeny
soggy105413903sog_gy
solely93714213solely
sonny85016103so_nny
sooey84522433sooe_y
sorely94618013sorely
sowens93613153sowens
stogey105811543stoge_y
sweeny12358843sweeny
teeny85417883_teeny
toggery12505923toggery
token95419313token_
tokens104711563tokens
toney86027413tone_y
tony75635153to__ny
towery124012093towery
towny116114493to_wny
tweeny12477003tweeny
urgency1345663urgency
urgent73816043urgent
volery1237873volery
weeny115316163_weeny
woken124614973woken_
women104619253women_
wooden103610303wooden_
woodenly1544293woodenly
woolen93111373woolen_
woolens10398843woolens
woven115215173woven_
wovens12449833wovens
xenogeny1943443xenogeny
yogee9518063yoge_e
yogees10510633yogees
yogin98317743yogin_
yogini10449143yogini
yogins105114103yogins
zooey173914803zooe_y
zoogenic2045973zoogenic

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 Limit1127163045.11022057.9
3Display Results3043040.0933268.8
 (SQL Overall)1786913045.57932029.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.