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

303 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
heptad123727(None) 
heptads1335871heptads
head87137172he__ad
heated104525592heated
hefted134911422hefted
hented104218752hented
hepcat13611822hepcat
heptane1238362heptane
hexad164910622he_xad
hoptoad1344322hoptoad
lepta75714392lepta_
pentad9313762pentad
peptid112712372peptid
septa75518082septa_
septal84513382septal
ahead96817053ahe__ad
bead75937923be__ad
beglad10138463beglad
behead1239923behead
belted94020633belted
bestead10389113bestead
bested94922753bested
bestud9439303bestud
beta66234133be_ta_
betas75528763be_tas
betta74916843betta_
bettas84913923bettas
betted94721163betted
captan101613343captan
centai84814783centai
cental84420963cental
centas85020703centas
cesta75419483cesta_
cestas85018543cestas
cheated134416343cheated
cheetah1545453cheetah
chested133811673chested
chetah14399583che_tah
dead65434243de__ad
delead84112343delead
delta66117773delta_
deltas74414823deltas
dental74319173dental
dented84120513dented
depend103510923depend
depth114311853dept_h
depths12428573depths
deputed114610173deputed
egad64215413_e_gad
epha9310053_epha_
ephah1337063_ephah
ephas10311543_ephas
ephod1139123_ephod
eta35834193_e_ta_
etas46432273_e_tas
felted103714653felted
festal94213563festal
feta76528903fe_ta_
fetal85623373fe_tal
fetas85624403fe_tas
feted94420933fe_ted
fetid93715983fe_tid
fetted104817893fetted
geta56627443ge_ta_
getas65421483ge_tas
had77658763h___ad
hafted134713833hafted
halted105019603halted
hanted104124313hanted
hapax1739323hap_ax
happed144820103happed
hapten115312983hapten
haptic13511883haptic
hartal9415473hartal
hasted105125283hasted
hated95734023h_ated
hatted104921513hatted
headed114020473headed
heads95127113he__ads
heady125117263he__ady
heal75645693he__al
healed105121443healed
heap96432893he__ap
heaped124516903heaped
hear76143883he__ar
heard95222753he_ard
hearted113314023hearted
heat77061423he__at
heater94828303heater
heath115724283heat_h
heaths126316383heaths
heathy156111213heathy
heats85838403heat_s
heaved134717863heaved
hectare1238463hectare
hectic132311513hectic
hector113312653hector
hedged125211793hedged
heed86437603he__ed
heeded114215763heeded
heehaw1543933heehaw
heeled104018413heeled
heeltap1243723heeltap
heezed194210513heezed
heft106736293heft__
hefter124313923hefter
hefts116218153heft_s
hefty146112133heft_y
heiled104415613heiled
heired103813043heired
heisted113210653heisted
hektare1435503hektare
held85330403he__ld
heliac111010893heliac
helipad1344723helipad
helled104024703helled
helmed124513693helmed
helped124714153helped
helved134313703helved
hemal104419803he_mal
hematal1238953hematal
hemmed144211463hemmed
hemoid12313513hemoid
henna84414043henna_
hennaed1135103hennaed
hennas94211803hennas
hent76656383hent__
hents87330743hent_s
hep86644143hep___
hepatic141712773hepatic
hepcats1436473hepcats
hepper133412663hepper
heptagon1443573heptagon
heptanes1339003heptanes
heptarch1843563heptarch
heptose1237493heptose
herald10311343herald
herbal112513493herbal
herbed123513453herbed
herd84933063he__rd
herded114215643herded
hereat93527413hereat
herma105318883herma_
hermae115314473hermae
hermai118912843hermai
hertz174919033hert_z
hest75950773hest__
hests85829933hest_s
het67674313he_t__
heth107028023he_t_h
heths116317783he_ths
hetman112510603hetman
hets75547203he_t_s
hewed125619433he_wed
hexade17438903he_xade
hexads17468193he_xads
hexed165615763he_xed
heyday1635143heyday
hiatal9310193hiatal
hilted104016043hilted
hinted104318323hinted
hipped144317693hipped
histed104420243histed
hodad10311353h_odad
hooted104422653hooted
hoped115628183hop_ed
hophead16337923hophead
hopped144318113hopped
hoptoads1444143hoptoads
hosta85917833hosta_
hostas94515823hostas
hosted105020343hosted
hotted104319933hotted
hunted104417013hunted
huppah1644183huppah
hutted104616333hutted
hyetal1236543hyetal
hyped145313333hyp_ed
hypha1637383hypha_
hyphae1746433hyphae
hyphal1736413hyphal
hypoed1547923hypoed
jehad1637683je_had
jested144416503jested
jetted143915083jetted
kepped15309533kepped
kept106232943kept__
keypad1633823keypad
lead56038853le__ad
leotard846193leotard
lept66440883lept__
leptin82512333leptin
lepton82510793lepton
letted74118543letted
mead75531603me__ad
meatal84114733meatal
meated94222403meated
mediad104313713mediad
melted94219063melted
menad85918983me_nad
menta74424423menta_
mental84521603mental
meta65932413me_ta_
metal75427383me_tal
meted85424433me_ted
nectar838853nectar
nepeta837893nepeta_
nepetas935943nepetas
nested74720063nested
netted74118713netted
octad81510653_octad
opted84914273_opted
pad68057323__p_ad
pelted94617753pelted
pentads1039523pentads
pepla9312863pepla_
pepped103113393pepped
peptalk1554823peptalk
peptic122113153peptic
peptide122910683peptide
peptids12239323peptids
petal76526893pe_tal
petard95013803pe_tard
petted94121523petted
read55942533re__ad
reata54225393reata_
reatas64021013reatas
reclad9311873reclad
recta74220263recta_
rectal84418133rectal
reload7413893reload
rental63922023rental
rented74426593rented
repaid94716323repaid
repand95316063repand
repay104818453rep_ay
repeal84718283repeal
repeat85127213repeat
replan83215823replan
replay113412923replay
replead10399003replead
repled93319773repled
repped114616723repped
reptant92817073reptant
reputed104613483reputed
reread71715433reread
rested74430783rested
retag63618413re_tag
retard75018933re_tard
retax124517973re_tax
retted74826313retted
seated75131053seated
seitan62613233seitan
sepal77723003sep_al
sepia75318673sepia_
sepias83616103sepias
sept65844363sept__
septage1078403septage
septate9511873septate
septet8921133septet
septic102713183septic
septs75420603sept_s
septum1037993septum
seta45637313se_ta_
setae56026223se_tae
setal56430903se_tal
sextan13389643sextan
sheeted113813033sheeted
sheitan1036563sheitan
shelta93111783shelta_
sheltas10279663sheltas
tad47959823___tad
teated74924023teated
tecta74215523tecta_
tectal83713253tectal
tempted12317283tempted
tented74221003tented
tepa66021683tep_a_
tepal76319583tep_al
tepas76521683tep_as
tepid8314313tep_id
testa54822043testa_
testae64216253testae
tested74421523tested
tetrad73612053tetrad
theta83414573the_ta_
thetas93011573the_tas
vented104617923vented
vesta86618303vesta_
vestal94615573vestal
vestas95916683vestas
vested104217353vested
vetted104316323vetted
weeted103913793weeted
welted103715823welted
wept95635053wept__
wetted103717023wetted
whetted14256693whetted
yenta83917043yenta_
yentas94614213yentas
zested164214043zested
zeta135121643ze_ta_
zetas145018163ze_tas

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 Limit1127163036.22018121.5
3Display Results3033030.0933258.1
 (SQL Overall)1786913036.45327691.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.