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

104 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
hektares153581(None) 
hectares1338851hectares
hektare1435501hektare_
centares102913892centares
dekares122710872dek_ares
hectare1238462hectare_
heptanes1339002heptanes
betakes134212523be_takes
bewares12313373be_wares
centare93113703centare_
centiares1167653centiares
centres93817123cent_res
cetanes9315133ce_tanes
decares102818533de_cares
deciares11510633deciares
declares11611313declares
dekare112811563dek_are_
dentures9312453dentures
ectases92911673_ectases
entases72816273_entases
entires71517783_entires
estates74520183_estates
etapes85415293_e_tapes
features11310333features
geotaxes1644743geotaxes
gestates93213733gestates
gestures9310013gestures
haftaras14136073haftaras
halteres113414593halteres
hares86255543h___ares
hearer94323643he__arer
hearers104319783he__arers
hears86737373he__ar_s
hearse94114273he__arse
hearses104414533he__arses
hearts96218943he__arts
heaters104225223heater_s
heathers143914733heathers
heaves124120303he__aves
hebetates1446433hebetates
hectored1436873hectored
hectors123513263hector_s
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
hostages122311693hostages
lectures101310153lectures
lekvars1432693lekvar_s
leotards945303leotards
meltages1148243meltages
metages102714973me_tages
metates92720013me_tates
metres85121563me_t_res
nectaries1149813nectaries
nectars938463nectar_s
pectases122411193pectases
pectates122213953pectates
pentanes10316083pentanes
petards104311153pe_tards
redwares1239053redwares
restages92815773restages
restarts8310873restarts
restates83423433restates
restores85222993restores
retakes113718863re_takes
retapes93917423re_tapes
retards85015003re_tards
retaxes143615093re_taxes
retires74726213re_tires
rheotaxes1943573rheotaxes
seawares1139333seawares
sectaries11312243sectaries
septages1168263septages
stares66038753__stares
tares57456563___tares
teawares1148083teawares
tektites1236613tektites
tentages91011043tentages
testates83615453testates
textures1597523textures
theatres11298633theat_res
upstares10178583upstares
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.1731032896.0
2DLD Change Limit1461621047.51319454.5
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.73223110.6
 
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.