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

447 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
obeahs113586(None) 
obeah1038991obeah_
beads85429502_beads
beaks115326622_beaks
beams95328172_beams
beans75734692_beans
bears75739042_bears
beats76042242_beats
beaus75127112_beaus
beths105519222_beths
blahs105616512_blahs
obas65730932ob_a_s
obeahism1542872obeahism
obelus8348402obelus
obes66036832obe__s
obeys107010642obe_ys
obias76116852obia_s
oceans81211002oceans
odahs95610082o_dahs
okehs12477462oke_hs
opahs105411982o_pahs
oreads73915772oreads
yeahs115214552_yeahs
aahs716428563__aahs
abas68642083ab_a_s
abash106016513ab_ash
abbas95918643abba_s
abeam9316533abea_m
abeles84719393abeles
abets75621673abe_ts
ahs68644823___ahs
alephs1136533alephs
almahs118611613almahs
amahs107819063_amahs
anears63717183anears
areas55935773area_s
ayahs116813523_ayahs
baals76122703_baals
baas66844673_b_aas
bads77048863_b_ads
bags76645503_b_ags
bah87755353_b_ah_
baht96740013_b_aht
bahts105617803_b_ahts
bals66354043_b_als
bams87044453_b_ams
bans66555133_b_ans
baps86040843_b_aps
bars66564093_b_ars
bas58681753_b_a_s
bash915240163_b_ash
bass66146783_b_ass
baths105922923_baths
bats66962333_b_ats
bays97143913_b_ays
beach124623893_beach
beaches144120653_beaches
beachy164011253_beachy
bead75937923_bea_d
beady114719923_beady
beak106534383_bea_k
beaky146118023_beaky
beam86939233_bea_m
beamy126218573_beamy
bean66443863_bea_n
beano75421553_beano
beanos85516513_beanos
bear66844643_bea_r
beard86024963_beard
beards94116673_beards
beast76338643_beast
beasts84519723_beasts
beat66168303_bea_t
beau66137273_bea_u
beaut75135213_beaut
beauts86015283_beauts
beaux146513213_beaux
becaps123811403_becaps
becks135522013_becks
beds75937783_be_ds
beefs105618563_beefs
beeps95320973_beeps
beers75628393_beers
bees65453383_be_es
beets76131443_beets
begs75733833_be_gs
belays114313853_belays
bells76432163_bells
bels66142493_be_ls
belts75931163_belts
bemas96424283_bemas
bends85628973_bends
benes75536233_benes
bens65945703_be_ns
bents76033693_bents
bergs84718043_bergs
berks115423123_berks
berms95323663_berms
berths114712423_berths
bes56557433_be__s
beses75830723_beses
bests75932613_bests
betas75528763_betas
beth96629233_beth_
bets67051443_be_ts
beys913829553_be_ys
bias64738153_bia_s
bimahs13508303bimahs
blabs95619633_blabs
blah98625063_blah_
blams95023853_blams
blats75132503_blats
blaws105620463_blaws
bleaks125112433bleaks
blears85116453blears
bleats85518613bleats
boars75229603_boars
boas66150833_boa_s
boats75635153_boats
bobcats1335993bobcats
bobeche1643843bobeche
bobeches1744483bobeches
bogans95714813bogans
bogbeans1343453bogbeans
boheas114013213bohea_s
bolas74733763bola_s
booths115313793booths
borals86721913borals
boras75938303bora_s
boreas85421733borea_s
botas75328783bota_s
boughs125414373boughs
boyars115611983boyars
brachs134415753_brachs
brads85528293_brads
braes75735053_braes
brags85625103_brags
brans75437433_brans
bras65746453_bra_s
brash106221563_brash
brass75428023_brass
brats75336013_brats
braws106425193_braws
brays106723113_brays
breads95419203breads
breaks124816423breaks
breams104815043breams
breaths124411183breaths
cheaps134613683cheaps
cheats114519543cheats
chetahs15347073chetahs
cheths14389823cheths
cleans85817053cleans
clears84116563clears
cleats84919313cleats
cobias104014973cobia_s
cobras104014193cobra_s
coheads13289233coheads
coleads102911423coleads
coprahs14338153coprahs
creaks124315963creaks
creams104715253creams
dahs88231813__dahs
deads75726913_deads
deals65435343_deals
deans66131393_deans
dears65736883_dears
deash95617243_deash
deaths105914443_deaths
debags104211063debags
debars94218043debars
debeaks1436103debeaks
doblas93812293dobla_s
dobras94811913dobra_s
dogears937513dogears
dourahs11487253dourahs
dreads84115023dreads
dreams94513983dreams
drears74614253drears
ears46356593__ears
eats47054873__eats
edhs86212103__edhs
ephahs1435503ephahs
eths76619523__eths
fears84829393_fears
feats86432753_feats
fehs106522383_fe_hs
fleams115011943fleams
fleas86423663flea_s
forbears1337073forbears
foveas1238623fovea_s
freaks134713063freaks
galahs105512673galahs
gears64628693_gears
gerahs1039413gerahs
gleams94812253gleams
gleans75014743gleans
gobans94412043gob_ans
greats76318393greats
hahs108333363__hahs
heads95127113_heads
heals85733453_heals
heaps105223223_heaps
hears86737373_hears
heaths126316383_heaths
heats85838403_heats
hehs106723963_he_hs
heths116317783_heths
hookahs17446653hookahs
hoorahs13399603hoorahs
horahs126313873horahs
houdahs1434243houdahs
howdahs1733613howdahs
ibexes15436163ibexes
ideals75012503ideals
ideas65919013idea_s
jeans126022113_jeans
josephs19161833josephs
jubbahs2143623jubbahs
jubhahs2242353jubhahs
kbars114612603kb_ars
keas86337093_kea_s
kebabs14418503kebabs
kebars124112493kebars
keblahs1634563keblahs
khedahs1852953khedahs
kheths16495973kheths
kiblahs1634153kiblahs
kneads11357093kneads
leads66028493_leads
leafs85721183_leafs
leaks95923913_leaks
leans55536253_leans
leaps75522933_leaps
lears55938733_lears
leas45954183_lea_s
leash85519213_leash
lobes75331003lobe__s
loofahs13364623loofahs
lotahs9479873lotahs
meads85425323_meads
meals75933373_meals
means75831223_means
meats75034053_meats
meths105320233_meths
mobcaps1543463mobcaps
mollahs12328283mollahs
moolahs12347383moolahs
mynahs14416443mynahs
neaps75618323_neaps
nears55529423_nears
neats55931903_neats
oafs76425263o__afs
oaks86527903o__aks
oars46846033o__ars
oaths86117313o_aths
oats46554213o__ats
oba57531553ob_a__
obe56638643obe___
obeahisms1642853obeahisms
obeli73711933obe_li
obelia8329453obelia
obelias9279033obelias
obelise9310173obelise
obelisk1345193obelisk
obelism1138203obelism
obento837893obento
obentos936703obentos
obese75212423obe_se
obey96521303obe__y
obeyed1235823obeyed
obeyer1135893obeyer
obeyers1234813obeyers
obia67923103obia__
obis66226833ob__is
obits74617543ob_its
objects18123693objects
objets15125323objets
oblast8613663oblast
oblasts947293oblasts
oblate82214743oblate
oblates91913243oblates
oboes75717713ob_oes
oboles83815833oboles
obols73715863ob_ols
obolus8378813obolus
obsess845943obsess
obtain839183obtain
obtains939163obtains
obtests9136233obtests
obverts1235403obverts
ocas66729633o_ca_s
ocean71212963ocea_n
octads987333octads
octans81411143octans
odah87018933o_dah_
odas57230263o_da_s
odea56224573odea__
odeons739023odeons
odes57243243ode__s
odeums9367313odeums
oes35866193o_e__s
ofays11488923o_fays
offals1235893offals
offbeats1682813offbeats
ogams84112683o_gams
ogees65119143oge_es
oghams1245853oghams
ohias84415563ohia_s
ohs66232313o___hs
okas85225393o_ka_s
okays12609443o_kays
okeh114615323oke_h_
okes84936343oke__s
okras94410973okra_s
olea46532723olea__
oleate6318883oleate
oleates7417833oleates
oleins6313523oleins
oleos55419683ole_os
oles46453473ole__s
oleums8358783oleums
ollas54218283olla_s
ombers104214393ombe_rs
omegas936973omegas
omens75618963ome_ns
omers76923193ome_rs
ones46146533one__s
onlays9398713onlays
oohs75220693o__ohs
oompahs1434263oompahs
oomphs1344723oomphs
opah96218403o_pah_
opals75718353o_pals
opens76118553ope_ns
operas8312453operas
opes65942613ope__s
orals55826483o_rals
orcas75918623orca_s
ordeals877993ordeals
oread64619603orea_d
ores46056683ore__s
organs7912913organs
orgeats838353orgeats
oses46641513ose__s
ottars64112223ottars
ouphs104311273o_uphs
outbeams1236063outbeams
outeats72215703outeats
ovals85413393o_vals
ovens86217453ove_ns
overs85224793ove_rs
owes75137103owe__s
oxes116530723oxe__s
oxeyes1635893oxeyes
oyers87620883oye_rs
oyes74940133oye__s
oyezes1835053oyezes
paeans85118263paeans
peags86122843_peags
peaks114825623_peaks
peals75235493_peals
peans75437643_peans
pears75138613_pears
peas65755063_pea_s
peats76140193_peats
pechs125516203_pechs
pehs95625763_pe_hs
pleads94613953pleads
pleas75627033plea_s
pleats85218593pleats
pujahs18404943pujahs
queans153110753queans
rajahs16497663rajahs
rayahs12579193rayahs
reads64835273_reads
reals55038653_reals
reams75729623_reams
reaps75626193_reaps
rears54739653_rears
rebars84019823rebars
rheas84816953rhea_s
robes75133303robe__s
seals54839693_seals
seams75731663_seams
sears54744913_sears
seas45755273_sea_s
seats54844343_seats
selahs9313213selahs
shahs115919513_shahs
sheafs124912883sheafs
sheals94420643sheals
shears93820903shears
sheas86331793shea_s
sheaths1358743sheaths
skeans104512913skeans
smears84714433smears
sneaks104312493sneaks
sneaps84510863sneaps
sobas74424253sob_a_s
sobers85218853sobe_rs
soybeans1343283soybeans
speaks125114583speaks
speans85417143speans
spears84019473spears
steads74116223steads
steaks104415853steaks
steals64020063steals
steams84916903steams
subahs114512383subahs
surahs94515543surahs
swears94114073swears
sweats94814613sweats
teaks94222903_teaks
teals56234133_teals
teams75726513_teams
tears55436463_tears
teas45851493_tea_s
teats55636813_teats
techs106915833_techs
teths85418513_teths
toeas55726423toea_s
torahs95115643torahs
treads74817913treads
treats64821693treats
tweaks1335963tweaks
unbears998043unbears
upbears1195423upbears
upbeats1195733upbeats
ureas55826013urea_s
uveas84912283uvea_s
veals84926193_veals
weals85428743_weals
weans85326743_weans
wears86030303_wears
wheals124512523wheals
wheats125013223wheats
wreaks134711113wreaks
wreaths13338373wreaths
yeah106725413_yeah_
yeans86624883_yeans
years84527673_years
yeas78638423_yea_s
yechs136112583_yechs
zeals145320853_zeals
zibeths2142933zibeths
zoeas145815613zoea_s

Search took 7 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.1401276364.3
2DLD Change Limit1127164475.78319490.9
3Display Results4474470.1403192.9
 (SQL Overall)1786914476.06329472.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.