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

114 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
hektare143550(None) 
hectare1238461hectare
hektares1535811hektares
centare93113702centare
dekare112811562dek_are
hectares1338852hectares
heptane1238362heptane
betake124512703be_take
beware11313713be_ware
centares102913893centares
centiare1067203centiare
centre84316643cent_re
cetane8315283ce_tane
decare93919153de_care
deciare10710663deciare
declare10411223declare
dekares122710873dek_ares
dentate8315153dentate
denture8311893denture
entire61617703_entire
estate64719763_estate
etape74413703_e_tape
feature1039853feature
gestate83614073gestate
gesture839243gesture
haftara13136093haftara
haltere103614713haltere
hare76255733h___are
hastate10313913hastate
hear76143883he__ar_
heard95222753he__ard
hearer94323643he__arer
hears86737373he__ars
hearse94114273he__arse
heart85440743he__art
heatable131612043heatable
heater94828303heater_
heaters104225223heaters
heather133914853heather
heave114521813he__ave
hebetate1347053hebetate
hector113312653hector_
hectored1436883hectored
hectors123513263hectors
hefter124313923hefter_
hefters134312003hefters
heftier1337203heftier
hegari1039523he_gari
helotage1245713helotage
henbane1237353henbane
heptad1237273hepta_d
heptads1335873heptads
heptanes1339003heptanes
heptarch1843563heptarch
heptose1237493heptose
herbage1337003herbage
here76447103he___re
heritage1246533heritage
hermae115314473herma_e
hesitate1169973hesitate
hetaera1036493he_taera
hetaerae1145533he_taerae
hetaira1045903he_taira
hetero9312633he_tero
hexade17438903he_xade
hexane16379533he_xane
hostage113111233hostage
lecture9149523lecture
lekvar1333043lekvar_
lekvars1432693lekvars
leotard846193leotard
meltage1037953meltage
metage93114453me_tage
metate82720533me_tate
metre74821303me_t_re
nectar838853nectar_
nectars938463nectars
nectary1246223nectary
pectase112410363pectase
pectate112214693pectate
peltate92013773peltate
pentane9415743pentane
petard95013803pe_tard
redware1139363redware
restage83316193restage
restart7320033restart
restate73824883restate
restore75822983restore
retake104718533re_take
retape83917683re_tape
retard75018933re_tard
retire64927013re_tire
retore67630773re_tore
seaware1049633seaware
sectary1238273sectary
septage1078403septage
septate9511873septate
setae56026223se_ta_e
stare54440263__stare
tare45957623___tare
tartare73012683tartare
teaware1048143teaware
tektite1136883tektite
tentage81010643tentage
testae64216253testa_e
testate73916233testate
texture1497083texture
theatre10358493theat_re
upstare9158683upstare
ventage11109623ventage
venture10311173venture
vesture10310373vesture
welfare1335713welfare
wetware1335793wetware

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.423422437.4
2DLD Change Limit1340271146.67020094.0
3Display Results1141140.0333454.5
 (SQL Overall)1786911147.12625075.9
 
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.