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

357 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
ogham113825(None) 
ogam75120031og_am
oghams1245851oghams
agha87417302agha_
aghas97014872aghas
cham115532312_cham
gam67060062_g_am
ghat86435282_ghat
glam76529342_glam
gram77034582_gram
ham86363282__ham
logjam1635362logjam
ogams84112682og_ams
oghamic1544042oghamic
ohm86523012o_h_m
sham96436362_sham
wham125321692_wham
abeam9316533abeam
afghan1333873afghan
aga410447233ag_a_
agama85815583ag_ama
agar58726413ag_ar
agas55938843ag_as
aghast105711373aghast
agism84614063agism
agleam9158623agleam
agma77623263agma_
agmas85919873agmas
aha611246643_aha_
ahem97225363_ahem
am411875563___am
arhat8327093arhat
ashram1139053ashram
bam78560143__bam
beam86939233_beam
blam86131703_blam
bogan87519003bog_an
bream95121813bream
brougham1642973brougham
cam78058983__cam
chad105525503_chad
chai95929903_chai
champ145017963_champ
chams126028503_chams
chao95727313_chao
chap114928493_chap
char95132153_char
charm126124663_charm
chasm125518793_chasm
chat95546133_chat
chaw126224633_chaw
chay124924873_chay
chum116318003_chum
clam86332293_clam
cognac1157273cognac
cogway1566183cogway
cram85635493_cram
cream95721353cream
dam67457043__dam
dhak125512033_dhak
dhal86719283_dhal
diram84419473diram
dirham12378273dirham
dogdom1186363dogdom
dogear838193dogear
dogma96112463dogma_
dogmas105011243dogmas
dognap1035343dognap
dram75832003_dram
dream85120393dream
dunam8313733dunam
egad64215413eg_ad
egal55119433eg_al
eggar7458883eggar
engram9310653engram
epha9310053epha_
ephah1337063ephah
ephas10311543ephas
exam132514623_exam
flam96333293_flam
fleam106017283fleam
foam97127173_foam
foram105124933foram
fulham1435303fulham
gab67155993_g_ab
gad57556653_g_ad
gae46457703_g_ae
gag57753633_g_ag
gal46055513_g_al
gama77035523_g_ama
gamb96331843_g_amb
game76644323_g_ame
gamp98833213_g_amp
gams76648883_g_ams
gamy105427533_g_amy
gan48060133_g_an
gap67055613_g_ap
gar47259903_g_ar
gas48870253_g_as
gat46880513_g_at
gaum75726423_gaum
gay76856493_g_ay
gear55934973_gear
gem66840223_g_em
germ75428963_germ
geum75424553_geum
ghast95621223_ghast
ghats95818613_ghats
ghaut95919433_ghaut
ghazi1837443_ghazi
ghee85726113_ghee
ghi77019883_gh_i
ghis85020163_ghis
gingham1484463gingham
glad65624013_glad
glams85822933_glams
gleam86916733gleam
glim76026353_glim
gloam86015943gloam
glom75424383_glom
glum75825103_glum
gnar56021383_gnar
gnat56034433_gnat
gnaw86515743_gnaw
goa47343803_goa_
goad66830983_goad
goal55829303_goal
goas55239943_goas
goat56250833_goat
goban84414073goban
goddam1145163goddam
golem8416113golem
gonad75216053gonad
goral65125753goral
gorm75529393_gorm
gowan95415743gowan
goyim1148603goyim
grab75427613_grab
grad66829863_grad
graham1237853graham
grama85620283_grama
gramp106218323_gramp
grams85327313_grams
gran56335013_gran
grat55651283_grat
gray85329893_gray
grim76929423_grim
grogram1147073grogram
grum75625083_grum
guan55325583_guan
guar56923293_guar
gum67439533_g_um
gym95719063_g_ym
ha510259943__ha_
had77658763__had
hae67364003__hae
haem95730983__haem
hag77255743__hag
hah910655223__hah
haha107821063haha_
hahas117118443hahas
haj138140603__haj
halm95834973__halm
hame97043133__hame
hams96446133__hams
hao67251123__hao
hap87360053__hap
harm95637793__harm
has67372653__has
hat67289963__hat
haw97153273__haw
hay97358773__hay
hem86148733__hem
him86247663__him
hm78126733__h_m
hmm106218993__hmm
hogan97817703hog_an
hum85542933__hum
ihram10310183ihram
imam81718333_imam
isogram1047253isogram
jam126942523__jam
jehad1637683jehad
jihad1635913jihad
joram145816983joram
kalam11315113kalam
khaf145319603_khaf
khan115819143_khan
khat116730723_khat
lahar83114263lahar
lam57666713__lam
loam65630483_loam
lochan1139093lochan
logan68123283log_an
logia68116603logia_
logjams1743583logjams
logway1335913logway
madam10316223madam
mocha1249923mocha_
mochas13310663mochas
moghul1244473moghul
moshav1446053moshav
mughal1236273mughal
nam55953393__nam
nizam16310253nizam
oaf65952883o__af
oak76238653o__ak
oakum1177313oakum
oar37057953o__ar
oat39888263o__at
oba57531553o_ba_
obas65730933o_bas
obeah1038993obeah
obia67923113obia_
obias76116863obias
oca56731733o_ca_
ocas66729633o_cas
ocean71212963ocean
ocher104516103ocher
ochre103411593ochre
ochry13346933ochry
octad81510653octad
octal71214723octal
octan71313483octan
oda48133043o_da_
odah87018933o_dah
odahs95610083odahs
odas57230263o_das
odea56224573odea_
odeum84610543odeum
odium83413033odium
ofay106416103o_fay
offal1136243offal
ogdoad943523ogdoad
ogee57629883og_ee
ogees65119143ogees
oghamist1444753oghamist
ogival1035873ogival
ogive9379093ogive
ogle56325053og_le
ogled75915963ogled
ogler65917443ogler
ogles65223183ogles
ogre56320743og_re
ogres65818633ogres
ogrism937913ogrism
oh57447003o_h__
ohed87825183o_hed
ohia75719363o_hia
ohias84415573ohias
ohms95514033o_hms
oho66534383o_h_o
ohs66232313o_h_s
oka76926803o_ka_
okas85225393o_kas
okay115917663o_kay
okra86413573okra_
okras94410973okras
olea46532723olea_
oleum73613323oleum
olla44821173olla_
ollas54218283ollas
om48553003o___m
onium73115533onium
onlay84212943onlay
oogamy1235633oogamy
ooh67637093ooh__
oohed94214213oohed
oohs75220693ooh_s
opah96218403o_pah
opahs105411983opahs
opal66923523o_pal
opium92812093opium
ora37250833o_ra_
orad56031693o_rad
oral47638123o_ral
orca65522773orca_
orcas75918623orcas
oread64619603oread
organ6915393organ
orgasm966303orgasm
orgeat7515033orgeat
orgiac934993orgiac
orphan1137733orphan
orra46120723orra_
osar46820953o_sar
ossa43714163ossa_
other84219103other
ottar54313993ottar
ought95221543ough_t
oughts104710183oughts
ova66823793o_va_
oval77119523o_val
ovum92310173o_vum
oxim131114053o_xim
pam77858393__pam
phat95837863_phat
pogrom1138593pogrom
praam94815613praam
pram85733493_pram
program12311693program
pshaw13447513pshaw
ram56867273__ram
ream65841613_ream
rehab10312443rehab
rehem103815353rehem
roam67132413_roam
scam85932353_scam
schav1338313schav
scram910621623scram
seam66645973_seam
sha69837783_sha_
shad86230913_shad
shag86430563_shag
shah105627783_shah
shame105726703_shame
shams105829413_shams
shat76456603_shat
shaw108132553_shaw
shawm135316153_shawm
shay107133343_shay
shim95827863_shim
slam67737973_slam
sorghum1343513sorghum
spam85930043_spam
steam76322933steam
swam96329983_swam
tam58663423__tam
team66238653_team
thae76825563_thae
than76128773_than
tharm105916643_tharm
that75639323_that
thaw107521313_thaw
them97427043_them
toga57027413tog_a_
togae67020113tog_ae
togas67823003tog_as
tram67034553_tram
ugh76520683ugh__
ughs85410973ugh_s
unhat81119263unhat
unjam1448723unjam
wha96422073_wha_
whamo135511263_whamo
whams135515643_whams
whap125119643_whap
what105434073_what
whim126220533_whim
whom127018183_whom
wigwam1544723wigwam
yam87448993__yam
yoga87418053yog_a_
yogas96615603yog_as
yogh116616143yogh__
yoghs125410593yogh_s
ziram163912893ziram

Search took 5 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 Filter178691836670.356501941.0
2DLD Change Limit836673573.95321165.4
3Display Results3573570.0933838.7
 (SQL Overall)1786913574.40240593.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.