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

186 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
hectare123846(None) 
hectares1338851hectares
hektare1435501hektare
centare93113702centare
decare93919152dec_are
deciare10710662deciare
declare10411222declare
hector113312652hector_
hectored1436872hectored
hectors123513262hectors
hektares1535812hektares
heptane1238362heptane
lecture9149512lecture
nectar838852nectar_
nectars938462nectars
nectary1246222nectary
pectase112410362pectase
pectate112214692pectate
sectary1238272sectary
acetate92514753acetate
became123213163bec_ame
becharm1636843becharm
betake124512703be_take
beware11313713be_ware
care66968373__c_are
centares102913893centares
centiare1067203centiare
centre84316643cent_re
cetane8315283ce_tane
chare105231983__chare
decade104216163dec_ade
decane93818873dec_ane
decares102818533dec_ares
decease1049523decease
deciares11510633deciares
declared1248743declared
declarer1148063declarer
declares11611313declares
dekare112811563de_kare
dentate8315153dentate
denture8311893denture
dictate10311663dictate
ecarte84313503_ec_arte
echard1249223_echard
ecotage1036883_ecotage
ectases92911673_ectases
ectype1334283_ectype
entire61617703_entire
estate64719763_estate
etape74413703_e_tape
facture12108923facture
feature1039853feature
gestate83614073gestate
gesture839243gesture
hachure1545723hachure
haftara13136093haftara
haltere103614703haltere
hare76255733h___are
hastate10313913hastate
hear76143883he__ar_
heard95222753he__ard
hearer94323643he__arer
hears86737373he__ars
hearse94114273he__arse
heart85440743he__art
heatable131612043heatable
heater94828303heater_
heaters104225223heaters
heather133914853heather
heave114521813he__ave
hebetate1347053hebetate
heckle153112093hec_kle
heckler16278573heckler
hectic132311523hect_ic
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
hoecake1645203hoec_ake
hostage113111233hostage
hotcake1644543hotcake
lactary1237843lactary
lactase937953lactase
lactate9312693lactate
lectern937033lectern
lector83514983lector_
lectors93415763lectors
lectured11127223lectured
lecturer10136023lecturer
lectures101310153lectures
leotard846193leotard
meltage1037953meltage
metage93114453me_tage
metate82720533me_tate
metre74821303me_t_re
nectarean1142913nectarean
nectaried1245443nectaried
nectaries1149813nectaries
nectarine1146983nectarine
nictate9310223nictate
octane81411633_octane
octave11157343_octave
peccary1636283peccary
pectases122411193pectases
pectates122213953pectates
pectize20259913pectize
peltate92013773peltate
pentane9415743pentane
petard95013803pe_tard
picture1158613picture
recane83022873rec_ane
recharge1476613recharge
rechart12314333rechart
reclame11411063reclame
recrate92621663recrate
recta74220263recta__
rectal84418133recta_l
rector84019753rector_
rectors93520523rectors
rectory123512733rectory
redware1139363redware
restage83316193restage
restart7320033restart
restate73824883restate
restore75822983restore
retake104718533re_take
retape83917683re_tape
retard75018933re_tard
retire64927013re_tire
retore67630773re_tore
scare75334463_sc_are
seaware1049633seaware
secpar1037923secpar_
secpars1138413secpars
sectaries11312243sectaries
sectile9311973sectile
sector83415933sector_
sectored1138063sectored
sectors93116453sectors
secure8513533sec_ure
septage1078403septage
septate9511873septate
setae56026223se_ta_e
spectate12248833spectate
spectre11297773spect_re
stare54440263__stare
tare45957623___tare
tartare73012683tartare
teaware1048143teaware
tecta74215523tecta__
tectal83713253tecta_l
tectite9310583tectite
tentage81010643tentage
testae64216253testa_e
testate73916233testate
texture1497083texture
theatre10358493theat_re
thecae11299653thec_a_e
thecate123210023thec_ate
upstare9158683upstare
vector113212063vector_
vectored1435623vectored
vectors123212593vectors
ventage11109623ventage
venture10311173venture
vesture10310373vesture
welfare1335713welfare
wetware1335793wetware

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271865.98622390.1
3Display Results1861860.0632952.4
 (SQL Overall)1786911866.45227695.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.