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

266 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
acetate9251475(None) 
acerate92818911acerate
acetated112010681acetated
acetates102013061acetates
acerated113113982acerated
acerbate1247532acerbate
acervate1336982acervate
aceta74017352aceta__
acetal84314902aceta_l
acetals93411352acetals
acetone9310792acetone
acetose938842acetose
acetylate1444212acetylate
acierate10311812acierate
actuate9311442actuate
acuate8315632ac_uate
acylate12310532acylate
aerate64830552a_erate
agemate101210582agemate
agitate8312062agitate
cerate84829462_cerate
cetane8315282_cetane
lacerate102214702lacerate
lactate9312692lac_tate
macerate122314072macerate
metate82720532_metate
pectate112214692pectate
racemate1239062racemate
scutate9310322scutate
abate76627843a__bate
abettal946073abettal
abetted1058323abet_ted
abetter958323abet_ter
ablate82219213a_blate
ablegate1147253ablegate
abnegate1144863abnegate
acaudate1145973acaudate
accentuate1453523accentuate
accrete1137843accrete
accurate12410663accurate
acerbated1465553acerbated
acerbates1347253acerbates
acerose9310893acerose
acetamid1344783acetamid
acetamide1443753acetamide
acetic10314503acet_ic
acetify1545003acetify
acetin8314693acet_in
acetins9313173acetins
acetones10310033acetones
acetous9410353acetous
acetum1038463acet_um
acetyl11396553acet_yl
acetylated1643163acetylated
acetylates1543843acetylates
acetyls12285353acetyls
achiote1239213achiote
acierated1238283acierated
acierates11310793acierates
acolyte12157643acolyte
aconite9315473aconite
acreage1037833acreage
acrylate1347693acrylate
acta69524803ac_ta__
actable11313473ac_table
activate13510373activate
active11313743ac_tive
actuated1138743actuated
actuates10310303actuates
aculeate1039913aculeate
acutance1246303acutance
acute74720363ac__ute
acylated1437863acylated
acylates1339743acylates
adequate1844303adequate
adnate72913483a_dnate
adulate8313233adulate
aerated85322373a_erated
aerates74627483a_erates
agate66525143a__gate
agemates111110023agemates
agitated1038413agitated
agitates9310873agitates
agitato856573agitato
agnate73314873a_gnate
airdate8311323airdate
alate55340323a__late
alienate8311553alienate
amebae1049633ameba_e
ameerate1039633ameerate
amesace1147733amesace
amirate91115953amirate
amputate1246263amputate
anatase738943anatase
animate91617213animate
annotate877713annotate
ansate64517863a_nsate
antae56828293a_nta_e
anteater8311603anteater
antedate949683antedate
aortae65115473aorta_e
apatite9312963apatite
apetaly1237253apetaly
apostate1049853apostate
appetite1258493appetite
arcuate9311963arcuate
areae55229743are_a_e
arenite71017713arenite
areolate81014453areolate
arete56031353are__te
ariette7312373ariet_te
aristate8312123aristate
arsenate81010483arsenate
asperate10312373asperate
astute6310763a_stute
aurate64426473a_urate
aureate72515283aureate
average1158853average
aviate9315203a_viate
baccate131011263bac_cate
backdate1748223backdate
berate84729023_berate
betake124512703_betake
bistate9313813bistate
bracteate1345353bracteate
calceate1239863calce_ate
cantata93811813cantata
capitate121712183capitate
carate84734003_carate
caretake1446773caretake
cartage10312593cartage
caseate9314783caseate
casemate1239843casemate
casette9310393caset_te
castrate10313863castrate
cate66254593_c__ate
catenate10312833catenate
caudate10311353caudate
cavitate13159833cavitate
cease75227653_ce_ase
cenote83715843_cenote
centare93113703_centare
cerated103922473_cerated
cerates95428233_cerates
cerite84724873_cerite
cetanes9315133_cetanes
cete64934783_ce__te
chelate122914893chelate
citrate92216793_citrate
comate104124843_comate
costate94019273costate
cottae84615703_cottae
crate76537403_c_rate
create85126373_create
cremate113816183cremate
crenate93317113crenate
curate85226243_curate
curtate9312643curtate
debate94419193_debate
delate73827753_delate
dentate8315153dentate
derate74531233_derate
dictate10311663dictate
ecotage1036883ecotage
edentate947703edentate
elate55335883__elate
elevate101110373elevate
enate54428143__enate
estate64719763_estate
etape74413703__etape
faceplate1645223faceplate
facete115014833face__te
facetiae1346213facetiae
facetted1445743facet_ted
galeate83916783gale_ate
galette84212693galet_te
gazette17357363gazet_te
gelate73421253_gelate
gestate83614073gestate
guttate8328903guttate
hastate10313913hastate
hebetate1347053hebetate
hectare1238463hectare
ideate7313683ide_ate
imitate9310873imitate
instate71616473instate
iterate71119103iterate
jaculate172311783jaculate
lacerated122210673lacerated
lacerates112413763lacerates
lactase937953lac_tase
lactated1138863lac_tated
lactates10311223lac_tates
lacunate10128963lacunate
layette1037133layet_te
legate72917453_legate
macerated142010523macerated
macerater13259523macerater
macerates132113563macerates
maculate122815623maculate
makebate1645063makebate
maleate94117543male_ate
metage93114453_metage
metates92720003_metates
mutate83017483_mutate
navette1036983navet_te
negate72915573_negate
nictate9310223nictate
notate63217863_notate
nutate63017373_nutate
ocellate1037863ocellate
ocreate93711743ocreate
octane81411633oc_tane
octave11157343oc_tave
octette946423octette
oleate6318883ole_ate
operate9615733operate
outate62923403_outate
overate10620963overate
paleate94120003pale_ate
palette93613983palet_te
pectase112410363pectase
pectates122213933pectates
pedate93117763_pedate
peltate92013773peltate
petite84320653_petite
phenate12412193phenate
predate10616893predate
prelate9519693prelate
pretape113511623pretape
pretaste10139523pretaste
racemates1348853racemates
raclette1047643raclet_te
rebate84424103_rebate
recrate92621643recrate
redate74124683_redate
relate64033633_relate
remate84428683_remate
restate73824873restate
retake104718533_retake
retape83917683_retape
retaste72313133_retaste
rotate63320343_rotate
saccate111311763sac_cate
sanitate8612043sanitate
scutage1036333scutage
sedate73019803_sedate
senate63725143_senate
septate9511873septate
setae56026223_seta_e
spectate12248833spectate
state56237333__state
tate44748603___tate
tectite9310583tectite
testate73916233testate
thecate123210023thecate
tractate10411003trac_tate
triacetate1263543triacetate
ulcerate1039733ulcerate
unstate71916213unstate
upstate91610493upstate
vacate11314553vac__ate
valerate11311463valerate
vegetate1246663vegetate
velate93720143_velate
vittate10409723vittate

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.1561145455.1
2DLD Change Limit1340272666.97019229.1
3Display Results2662660.0932860.2
 (SQL Overall)1786912667.21924752.9
 
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.