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

224 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
heppest1422814(None) 
hippest14219751hippest
cheapest1536072cheapest
deepest10310442deepest
happiest152411672happiest
hempiest1539022hempiest
hepper133412662heppe_r
herpes115517322herpes_
hippiest152611612hippiest
hoppiest152610722hoppiest
peppiest11278562peppiest
tempest1139222tempest
adeptest1145453adeptest
aeriest73924053aeriest
amplest11312333amplest
anapest9311553anapest
aptest82917513_aptest
bedpost1247243bedpost
behest11314613be_hest
bequest1837823bequest
cepes94424463ce_pes_
chewiest16177293chewiest
chippiest18256803chippiest
choppiest18226373choppiest
crepiest12310383crepiest
cuppiest1448193cuppiest
dampest12411043dampest
deadest93014883deadest
deafest112911513deafest
dearest83618673dearest
deffest14308803deffest
deftest112611713deftest
densest83112473densest
depress10239873depress
detest74122843de_test
devest104418703de_vest
dewiest11312343dewiest
dippiest132511133dippiest
dopiest103315993dopiest
eeliest73516473eeliest
eeriest73620673eeriest
egest65222343_e_gest
eldest72912683_eldest
epeeist938863_epeeist
epees75219833_epees_
expect1758903_expect
expert15515353_expert
featest102715113featest
fellest10313753fellest
fewest12311663fe_west
feyest12311403fe_yest
flippest1535173flippest
gappiest13259473gappiest
geest64829613ge__est
haddest122711993haddest
halest94823273h_alest
hapless123311333hapless
happed144820103happe_d
happen134812193happe_n
happens14359173happens
hardest113118413hardest
harpist12312353harpist
harvest132112753harvest
haziest193313003haziest
headiest123015553headiest
headrest122910203headrest
headset11312603headset
heaped124516903heape_d
heaper114119523heape_r
heapers123616673heapers
heaps105223223heap_s_
heaves124120303heaves_
heaviest143210443heaviest
hebes105521673he_bes_
hedges115016243hedges_
hedgiest13298133hedgiest
heelpost1355013heelpost
heezes184211643heezes_
heftiest1439183heftiest
heiress1036813heiress
heist87030913he__ist
heliast10312073heliast
helmet113718933helme_t
helmets12309073helmets
helped124714153helpe_d
helper114313093helpe_r
helpers123311853helpers
helpless1335063helpless
helpmeet1544253helpmeet
helps105219343help_s_
helves124316063helves_
hemes105031083he_mes_
hempen1338963hempe_n
hemps126917333hemp_s_
henges104516453henges_
henpeck1843083henpeck
hepcat13611823he_pcat
hepcats1436473hepcats
heptose1237493heptose
herbiest1339993herbiest
hereat93527413he_reat
heres86245903he_res_
heresy125011233he_resy
heroes94923823heroes_
hest75950773h___est
hexes155123043he_xes_
highest1439563highest
hipless12399923hipless
hipness12277383hipness
hipped144317693hippe_d
hipper133818023hippe_r
hippies142813743hippies_
hippish1736183hippish
hippos13408433hippos_
hokiest144114243hokiest
holiest104319623holiest
homiest124116633homiest
honest94822423h_onest
hopes105835643h_opes_
hopped144318113hoppe_d
hopper134218483hoppe_r
hoppers143115143hoppers
hopples142810713hopples_
hottest10411383hottest
hugest10311763h_ugest
humpiest1538963humpiest
hypes135818673h_ypes_
imprest11310203imprest
jimpest18297553jimpest
keenest11410963keenest
kepped15309533keppe_d
keppen14346563keppe_n
lappet103817723lappe_t
lappets11329123lappets
leanest7415863leanest
leftest10269463leftest
lewdest1136283lewdest
limpest113712313limpest
lippiest122310613lippiest
loppiest122410103loppiest
meanest9315703meanest
meekest1336893meekest
merest84725113me_rest
mopiest113014293mopiest
moppet126915093moppe_t
moppets13307163moppets
nappes104515623nappes_
nappiest122510883nappiest
nearest73415843nearest
neatest72516003neatest
newest9314213ne_west
nippiest12279973nippiest
openest9312913openest
pappiest112611113pappiest
pepped103113393peppe_d
pepper93512943peppe_r
peppers103311443peppers
peppery13286243peppery
perpent112318803perpent
pertest9317043pertest
pest65555293___pest
pipiest113114493pipiest
poppet92717323poppe_t
poppets10338853poppets
preppiest1236973preppiest
prest75736353__prest
puppet93514593puppe_t
puppets10317013puppets
realest73322433realest
reddest9311953reddest
reest54938093re__est
renest64529713re_nest
repast83520633re_past
repeat85127213re_peat
repent84728873re_pent
repped114616723reppe_d
repps95114343repp_s_
repress92712683repress
request16311023request
respect11412033respect
respelt9312143respelt
retest64028453re_test
revest94623603re_vest
ripest84317943_ripest
ropiest93317773ropiest
sappiest122612573sappiest
searest73322023searest
seepiest102412623seepiest
sepses84515883sepses_
septet8921133septe_t
septets998953septets
serest64831613se_rest
serpent92916283serpent
sexiest142112223sexiest
sharpest1339143sharpest
sheerest11310083sheerest
shoppes143411393shoppes_
sippet103519393sippe_t
sippets113310183sippets
soppiest122511933soppiest
steepest1038123steepest
steppes113110693steppes_
supplest1248943supplest
tappet103820113tappe_t
tappets113610013tappets
tempests1234443tempests
tensest72713313tensest
tepees84215243tepees_
tersest71713993tersest
thewiest14196343thewiest
tippet103917873tippe_t
tippets11339373tippets
tippiest122310013tippiest
typiest1238203typiest
veriest103719133veriest
weakest1439003weakest
weepiest13219473weepiest
weest85026773we__est
wettest10239363wettest
whippet17328843whippe_t
whippets18255253whippets
whippiest19265113whippiest
zappiest21228023zappiest
zippiest21248093zippiest

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272246.75319847.0
3Display Results2242240.0762947.4
 (SQL Overall)1786912246.98525582.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.