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

168 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
hectares133885(None) 
hectare1238461hectare_
hektares1535811hektares
centares102913892centares
decares102818532dec_ares
deciares11510632deciares
declares11611312declares
ectases92911672_ectases
hectored1436872hectored
hectors123513262hector_s
hektare1435502hektare_
heptanes1339002heptanes
lectures101310152lectures
nectaries1149812nectaries
nectars938462nectar_s
pectases122411192pectases
pectates122213952pectates
sectaries11312242sectaries
acetates102013063acetates
becharms1745343becharms
betakes134212523be_takes
bewares12313373be_wares
cares77369183__c_ares
centare93113703centare_
centiares1167653centiares
centres93817123cent_res
cetanes9315133ce_tanes
chares115631803__chares
decades113615513dec_ades
decanes103118913dec_anes
decare93919153dec_are_
deceases11410153deceases
deciare10710663deciare_
declare10411223declare_
declared1248743declared
declarer1148063declarer
declarers1236423declarers
dekares122710873de_kares
dentures9312453dentures
dictates11311383dictates
ecartes94212563_ec_artes
echards1337963_echards
ecotages1136973_ecotages
ectasis9249613_ectasis
ectypes1434803_ectypes
entases72816273_entases
entires71517783_entires
estates74520183_estates
etapes85415293_e_tapes
factures13129023factures
features11310333features
geotaxes1644743geotaxes
gestates93213733gestates
gestures9310013gestures
hachures1645873hachures
haftaras14136073haftaras
halteres113414593halteres
hares86255543h___ares
hearer94323643he__arer
hearers104319783he__arers
hears86737373he__ar_s
hearse94114273he__arse
hearses104414533he__arses
hearts96218943he__arts
heaters104225223heater_s
heathers143914733heathers
heaves124120303he__aves
hebetates1446433hebetates
hecklers17357123hecklers
heckles163711383hec_kles
hector113312653hector__
hefters134312003hefter_s
hegaris11310433he_garis
helotages1346123helotages
henbanes1336573henbanes
heptads1335873hepta_ds
heptane1238363heptane_
heptarch1843563heptarch
heptarchs1943043heptarchs
heptoses1338373heptoses
herbages1437093herbages
heres86245903he___res
heritages1346713heritages
hertzes1938303hert_zes
hesitates1269793hesitates
hetaera1036493he_taera
hetaeras1146733he_taeras
hetairas1145603he_tairas
heteros10312683he_teros
hexades18378703he_xades
hexanes17319463he_xanes
hoecakes1745323hoec_akes
hostages122311693hostages
hotcakes1744703hotcakes
lactases1038513lactases
lactates10311223lactates
lecterns1035943lecterns
lectors93415763lector_s
lecture9149513lecture_
lectured11127223lectured
lecturer10136023lecturer
lecturers11124233lecturers
leotards945303leotards
meltages1148243meltages
metages102714973me_tages
metates92720013me_tates
metres85121563me_t_res
nectar838853nectar__
nectarean1142913nectarean
nectaried1245443nectaried
nectarines1246893nectarines
nectarous1144713nectarous
nectary1246223nectar_y
nictates1039593nictates
octanes91111393_octanes
octaves12316963_octaves
peccaries1548533peccaries
pectase112410363pectase_
pectate112214693pectate_
pectines121914683pectines
pectizes21229793pectizes
pentanes10316083pentanes
petards104311153pe_tards
pictures1249343pictures
recanes93222263rec_anes
recharges1586953recharges
recharts1337663recharts
reclames12310893reclames
recrates102420373recrates
rectories11314643rectories
rectors93520523rector_s
redwares1239053redwares
restages92815773restages
restarts8310873restarts
restates83423433restates
restores85222993restores
retakes113718863re_takes
retapes93917423re_tapes
retards85015003re_tards
retaxes143615093re_taxes
retires74726213re_tires
rheotaxes1943573rheotaxes
scares85033003_sc_ares
seawares1139333seawares
secpars1138413secpar_s
sectary1238273sectar_y
sectored1138063sectored
sectors93116453sector_s
secures9613163sec_ures
septages1168263septages
spectates13228813spectates
spectres12268683spect_res
stares66038753__stares
tares57456563___tares
teawares1148083teawares
tectites1039993tectites
tentages91011043tentages
testates83615453testates
textures1597523textures
theatres11298633theat_res
upstares10178583upstares
vectored1435623vectored
vectors123212593vector_s
ventages12119773ventages
ventures11311493ventures
vestures11311043vestures
welfares1445543welfares
wetwares1445953wetwares

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 Filter1786911461620.486367677.0
2DLD Change Limit1461621686.70321805.5
3Display Results1681680.0602800.0
 (SQL Overall)1786911687.24924650.4
 
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.