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 “heads” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

262 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
heads9512711(None) 
beads85429501beads
deads75726911deads
head87137171head_
heady125117261heady
heals85733451heals
heaps105223221heaps
hears86737371hears
heats85838401heats
heeds95420421heeds
herds96424681herds
hexads17468191hexads
leads66028491leads
meads85425321meads
reads64835271reads
ads49755732__ads
ahead96817052ahead_
bads77048862_bads
bead75937922bead_
beady114719922beady
beaks115326622beaks
beams95328172beams
beans75734692beans
beards94116672beards
bears75739042bears
beats76042242beats
beaus75127112beaus
beds75937782be_ds
beheads1338522beheads
bends85628972bends
brads85528292brads
breads95419202breads
cads76144522_cads
chads116122232chads
cheaps134613682cheaps
cheats114519542cheats
clads85722732clads
coheads13289232coheads
dads67442772_dads
dead65434242dead_
deals65435342deals
deans66131392deans
dears65736882dears
deeds75423762deeds
dreads84115022dreads
duads76515342duads
dyads10549972dyads
ears46356592_ears
eats47054872_eats
eds46638922_e_ds
egads74610922egads
elds56324852_elds
ends56528522_ends
fads86939872_fads
fears84829392fears
feats86432752feats
feds85234312fe_ds
feeds94921142feeds
fends96324972fends
feods99516852feods
feuds95914882feuds
gads67843382_gads
gears64628692gears
geds66730812ge_ds
gelds75118342gelds
glads75620612glads
goads77022852goads
grads75625752grads
haafs115711162haafs
haars85620472haars
had77658762h_ad_
hade85440192h_ade
hades96035112h_ades
hadj155818672h_adj
hadst93220222h_adst
haed86338582haed_
haems105517012haems
haes77651022h_aes
haets86525122haets
hags86740842h_ags
hahs108333362h_ahs
hams96446132h_ams
hands95327382hands
haps96443462h_aps
hards96435652hards
has67372652h_a_s
hats76858252h_ats
haws106439442h_aws
hays106138072h_ays
headed114020472headed
header104422542header
headers113819392headers
headset11312602headset
heal75645692hea_l
heap96432892hea_p
heapy135914982heapy
hear76143882hea_r
heard95222752heard
hearse94114272hearse
heart85440742heart
hearts96218942hearts
heat77061422hea_t
heath115724282heath
heaths126316382heaths
heave114521812heave
heaves124120302heaves
heavy144814182heavy
hebes105521672hebes
hecks145220652hecks
heed86437602heed_
heels85625532heels
hefts116218152hefts
hehs106723962he_hs
heils85222192heils
heirs85618562heirs
held85330402held_
hells85032042hells
helms105619462helms
helos84928062helos
helps105219342helps
hemes105031082hemes
hemps126917332hemps
hems95534942he_ms
hens75642572he_ns
hents87330742hents
heptads1335872heptads
heralds1137712heralds
herbs105520502herbs
herd84933062herd_
heres86245902heres
herls85226432herls
herms105626432herms
herns84825582herns
heros84930862heros
hers75844872he_rs
hes66654202he__s
hests85829932hests
heths116317782heths
hets75547202he_ts
hews105631572he_ws
hexad164910622hexad_
hexade17438902hexade
hexades18378702hexades
hexes155123042hexes
hinds96721472hinds
hoards104912622hoards
hoars85925552hoars
hodads1147962hodads
hods87239862h_ods
holds94623242holds
hoods95124082hoods
hurds95219072hurds
jeans126022112jeans
jehads1735832jehads
keas86337092kea_s
khedas1446312khedas
kneads11357092kneads
lads56549132_lads
lead56038852lead_
leady95618602leady
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182lea_s
lends65326252lends
leuds66214812leuds
loads65323372loads
mads76845372_mads
mead75531602mead_
meals75933372meals
means75831232means
meats75034052meats
meds75735362me_ds
meeds84920272meeds
melds84822382melds
menads95514382menads
mends84927692mends
neaps75618322neaps
nears55529422nears
neats55931902neats
needs65719632needs
nerds65719252nerds
oreads73915772oreads
pads76742952_pads
peags86122842peags
peaks114825622peaks
peals75235492peals
peans75437642peans
pears75138612pears
peas65755062pea_s
peats76140192peats
peds75835242pe_ds
pends85527192pends
pleads94613952pleads
quads154515842quads
rads56046602_rads
read55942532read_
readd74617132readd
readds84111642readds
ready94821502ready
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
redds74617832redds
reds56042862re_ds
reeds65430902reeds
rends65129952rends
rheas84816952rhea_s
roads66523622roads
scads85419962scads
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
seeds64330062seeds
sends65528242sends
shads95124482shads
sheafs124912882sheafs
sheals94420642sheals
shears93820902shears
sheas86331792shea_s
sheds96122702she_ds
shends105313772shends
sherds105614722sherds
steads74116222steads
tads57143942_tads
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492tea_s
teats55636812teats
teds54932572te_ds
tends65425582tends
threads11419952threads
toads65621072toads
treads74817922treads
veals84926192veals
velds95615582velds
vends95520892vends
wads87343142_wads
wealds10459102wealds
weals85428742weals
weans85326742weans
wears86030302wears
weds86628932we_ds
weeds95222212weeds
welds94719162welds
wends95822812wends
wheals124512522wheals
wheats125013222wheats
woads94818442woads
yeahs115214552yeahs
yeans86624882yeans
years84527672years
yeas78638422yea_s
zeals145320852zeals
zeds145821802ze_ds

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538002621.57634137.1
3Display Results2622620.0803275.0
 (SQL Overall)1786912621.749102167.5
 
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.