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

164 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
oogamy123563(None) 
apogamy1543622apogamy
bigamy1436332bigamy
digamy1335882digamy
exogamy2042802exogamy
foamy135313202fo_amy
gamy105427532__gamy
hologamy1744402hologamy
homogamy1944342homogamy
isogamy1343992isogamy
loamy105913342lo_amy
monogamy1645102monogamy
ogam75120032_ogam_
ogams84112682_ogams
oogeny10117922oogeny
agama85815573_agama
allogamy1443993allogamy
angary10311323angary
autogamy1454813autogamy
beamy126218573_beamy
bogan87519003boga_n
bogans95714813bogans
bogart9617193bogart
bogey115220233bog_ey
boggy126116073bog_gy
bogy106426193bog__y
boogey124711523boog_ey
boogy114518323boog__y
boomy125421823bo_omy
bosomy13509033bosomy
botany1139263botany
coaly105521593co_aly
cogway1566183cogway
commy144712643co_mmy
copay126516313copa_y
covary1438743covary
creamy134811363creamy
degame102713183degame
degami10279003degami
dogey105719513dog_ey
doggy115214873dog_gy
dogma96112463dog_ma
dogmas105011243dogmas
dogy96126493dog__y
doomy116018263do_omy
dormy115817463do_rmy
dreamy12509993dreamy
endogamy1542983endogamy
flamy135217473_flamy
foam97127173fo_am_
foams105017953fo_ams
fogey125617873fog_ey
foggy136714543fog_gy
fogy115923183fog__y
foram105124933foram_
forams115115913forams
foray115023973fora_y
gaby107123193__gaby
gam67060063__gam_
gama77035513__gama
gamay116419103__gamay
gamb96331843__gamb
game76644323__game
gamey115320553__gamey
gammy135514893__gammy
gamp98833213__gamp
gams76648883__gams
gapy106320913__gapy
gay76856493__ga_y
gleamy12398113gleamy
goggly12337053goggly
googly11417883goog_ly
gowany13457493gowany
hoagy124710473ho_agy
hoary114516763ho_ary
hogan97817703hoga_n
hogans105914313hogans
homy126623223ho__my
hooray123011373hoora_y
horary12310383horary
infamy1435643infamy
joram145816983joram_
jorams154810533jorams
legacy1256653legacy
loam65630483lo_am_
loams75619863lo_ams
logan68123283loga_n
logans76319063logans
loggy105714193log_gy
logily1039833logily
logjam1635363logjam_
logjams1743583logjams
logway1335913logway
logy87025783log__y
misogamy1644083misogamy
moggy125212163mog_gy
mommy114010753mo_mmy
moray105423793mora_y
nongame1038173nongame
nongay10169153nonga_y
notary92310713notary
noway111112843nowa_y
oaky116419953_o_aky
ofay106416103_ofa_y
ogham1138253ogham_
oghams1245853oghams
okay115917663_oka_y
ology94113113olog__y
onlay84212943onla_y
oogamete11184933oogamete
oogamies1147413oogamies
oogamous1144773oogamous
oology103210253oology
oorali6311263oorali
oozily18328073oozily
oozy167018133oo__zy
organ6915393orga_n
organa789213organa
organdy1254573organdy
organs7912913organs
orgasm966303orgasm
orgasms1054293orgasms
orgy85218003org__y
origami1045433origami
orogeny11107023orogeny
ostomy1137823ostomy
ovary1149113_ovary
pigmy13299433pig_my
pogey116017893pog_ey
pogy105623553pog__y
polygamy1944063polygamy
pommy14449863po_mmy
pygmy16334223pyg_my
roam67132413ro_am_
roams74919613ro_ams
roomy107118063ro_omy
rosary92810353rosary
rotary92411303rotary
seamy105921273_seamy
soapy106114783so_apy
sodomy1276673sodomy
soggy105413903sog_gy
steamy115112373steamy
sugary1039013sugary
swamy136714403_swamy
syngamy1643103syngamy
toady96814343to_ady
today96416953toda_y
toga57027413toga__
togae67020113toga_e
togaed84711343togaed
togas67823003toga_s
togate74515683togate
tokay125513053toka_y
tommy124712233to_mmy
vagary1337333vagary
votary12248333votary
wormy137514253wo_rmy
xenogamy2142493xenogamy
yoga87418053yoga__
yogas96615603yoga_s
zonary1838793zonary
zoogeny2044363zoogeny
zootomy2154803zootomy

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.1431249587.4
2DLD Change Limit1127161644.98322620.1
3Display Results1641640.0762157.9
 (SQL Overall)1786911645.20234350.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.