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

338 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
heats8583840(None) 
beats76042241beats
cheats114519541cheats
eats47054871_eats
feats86432751feats
haets86525121haets
hats76858251h_ats
heads95127111heads
heals85733451heals
heaps105223221heaps
hears86737371hears
hearts96218941hearts
heat77061421heat_
heath115724281heath
heaths126316381heaths
hefts116218151hefts
hents87330741hents
hests85829931hests
hets75547201he_ts
meats75034051meats
neats55931901neats
peats76140191peats
seats54844341seats
teats55636811teats
wheats125013221wheats
bats66962332_bats
beads85429502beads
beaks115326622beaks
beams95328172beams
beans75734692beans
bears75739042bears
beast76338642beast
beasts84519722beasts
beat66168302beat_
beaus75127112beaus
beauts86015282beauts
beets76131442beets
belts75931162belts
bents76033692bents
bests75932612bests
betas75528762betas
bets67051442be_ts
blats75132502blats
bleats85518612bleats
boats75635152boats
brats75336012brats
cats66356342_cats
celts75325782celts
cents74730332cents
chats105730092chats
cheaps134613682cheaps
cheat105732452cheat_
cherts115617232cherts
chests114916262chests
cleats84919312cleats
coats75634992coats
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
death94822522death
deaths105914442deaths
debts86418372debts
deets65330242deets
defats105114552defats
delts65731792delts
dents65031802dents
derats74625062derats
doats65224882doats
drats66628372drats
ears46356592_ears
east46659102_east
easts57530322_easts
eat36989052_eat_
eath75735662_eath
efts76519482_efts
etas46432272_etas
fats76252502_fats
fears84829392fears
feast85932722feast
feasts95116092feasts
feat76458222feat_
felts85324542felts
fests85828042fests
fetas85624402fetas
fets75345942fe_ts
fiats85324482fiats
flats86429742flats
frats86829672frats
gats56753442_gats
gears64628692gears
gelts65924612gelts
gents65729612gents
gests66028812gests
getas65421482getas
gets55442482ge_ts
ghats95818612ghats
gnats65217712gnats
goats65527302goats
greats76318392greats
haafs115711162haafs
haars85620472haars
haems105517012haems
haes77651022h_aes
haet75659502haet_
hafts116219462hafts
hags86740842h_ags
hahs108333362h_ahs
halts85230102halts
hams96446132h_ams
hants86335402hants
haps96443462h_aps
harts88441592harts
has67372652h_a_s
hast76259482h_ast
hat67289962h_at_
hate78450172h_ate
hates86742572h_ates
hath105933912h_ath
haws106439442h_aws
hays106138072h_ays
head87137172hea_d
heady125117262heady
heal75645692hea_l
health124712142health
healths13478752healths
heap96432892hea_p
heapy135914982heapy
hear76143882hea_r
heard95222752heard
hearse94114272hearse
heart85440742heart
hearth125315212hearth
hearths135311072hearths
hearty126313632hearty
heated104525592heated
heater94828302heater
heaters104225212heaters
heathy156111212heathy
heave114521812heave
heaves124120302heaves
heavy144814182heavy
hebes105521672hebes
hecks145220652hecks
heeds95420422heeds
heels85625532heels
heft106736292heft_
hefty146112132hefty
hehs106723962he_hs
heils85222192heils
heirs85618562heirs
heist87030912heist
heists96814632heists
hells85032042hells
helms105619462helms
helos84928062helos
helots95217702helots
helps105219342helps
hemes105031082hemes
hemps126917332hemps
hems95534942he_ms
hens75642572he_ns
hent76656382hent_
hepcats1436472hepcats
herbs105520502herbs
herds96424682herds
heres86245902heres
herls85226432herls
herms105626432herms
herns84825582herns
heros84930862heros
hers75844872he_rs
hertz174919032hertz
hes66654202he__s
hest75950772hest_
het67674312he_t_
heth107028022he_th
heths116317782heths
hews105631572he_ws
hexads17468192hexads
hexes155123042hexes
hiatus938222hiatus
hilts86924412hilts
hints87330622hints
hists86328372hists
hits75545132h_its
hoars85925542hoars
holts85627912holts
hoots84830242hoots
hosts85526702hosts
hots78349322h_ots
hunts86826172hunts
hurts86922822hurts
huts76737442h_uts
ikats95311152ikats
jeans126022112jeans
jests125922452jests
jets115834102je_ts
kats85944332_kats
keas86337092kea_s
keets95123482keets
kelts95222632kelts
khats125316012khats
khets124913432khe_ts
kyats125012442kyats
lats45962702_lats
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182lea_s
least56134882least
leasts64616412leasts
leets54927122leets
lefts86517812lefts
lets47147942le_ts
mats65460282_mats
meads85425322meads
meals75933372meals
means75831222means
meat66359602meat_
meatus85112922meatus
meaty107021312meaty
meets74224612meets
melts74930102melts
moats75827642moats
neaps75618322neaps
nears55529422nears
neat46356782neat_
neath86020282neath
nerts55924982nerts
nests55728002nests
nets45941532ne_ts
netts55320722netts
newts86015282newts
oats46554212_oats
pats66460852_pats
peags86122842peags
peaks114825622peaks
peals75235492peals
peans75437642peans
pears75138612pears
peas65755062pea_s
peat65967932peat_
peaty105725692peaty
pelts76128812pelts
pests75933272pests
pets66248332pe_ts
plats75531372plats
pleats85218592pleats
prats76333392prats
qats135331342_qats
rats46260372_rats
reacts83616602reacts
reads64835272reads
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
reata54225392reata
reatas64021012reatas
reheats104513522reheats
rents55935182rents
rests54935872rests
rets45352562re_ts
rheas84816952rhea_s
scats75930602scats
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seat47575562seat_
sects75622892sects
septs75420602septs
sets45549502se_ts
setts55124322setts
sexts125118382sexts
sheafs124912882sheafs
sheals94420642sheals
shears93820902shears
sheas86331792shea_s
sheath12412882sheath
sheaths1358742sheaths
sheets93918492sheets
shoats94117072shoats
skats94621532skats
slats55436902slats
spats75031382spats
stats55933362stats
swats85726862swats
sweats94814612sweats
tats46858132_tats
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492tea_s
teat45963632teat_
tents56434212tents
tests56530192tests
tets45847452te_ts
texts125515042texts
thefts12387922thefts
thetas93011572thetas
threats104311672threats
treats64821692treats
twats86616602twats
vats76841742_vats
veals84926192veals
vents86125932vents
verts85724732verts
vests85325982vests
vets76835092ve_ts
wats77555882_wats
weals85428742weals
weans85326742weans
wears86030302wears
weets85427722weets
wefts116715492wefts
welts85225192welts
wests85727002wests
wets75940292we_ts
whats117718992whats
wheals124512522wheals
wheat114924572wheat_
whets115019612whe_ts
yeahs115214552yeahs
yeans86624882yeans
years84527672years
yeas78638422yea_s
yeast85327942yeast
yeasts96413052yeasts
yetts86715132yetts
zeals145320852zeals
zests145419742zests
zetas145018162zetas

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 Limit538003381.78330173.9
3Display Results3383380.0933634.4
 (SQL Overall)1786913381.96990752.2
 
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.