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

223 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
acetates10201306(None) 
acetate92514751acetate_
acetated112010681acetated
acerate92818912acerate_
acerated113113982acerated
acerbates1347262acerbates
acetals93411352aceta_ls
acetones10310032acetones
acetylates1543852acetylates
acierates11310812acierates
actuates10310312actuates
acylates1339742acylates
aerates74627492a_erates
agemates111110022agemates
agitates9310882agitates
cerates95428252_cerates
cetanes9315132_cetanes
lacerates112413772lacerates
lactates10311222lac_tates
macerates132113572macerates
metates92720012_metates
pectates122213952pectates
racemates1348852racemates
abates85825033a__bates
abettals1054723abettals
abetted1058323abet_ted
abetter958323abet_ter
abetters1057173abet_ters
ablates92416903a_blates
ablegates1246793ablegates
abnegates1244943abnegates
accentuates1553063accentuates
accretes1238113accretes
acerbate1247533acerbate_
acerbated1465553acerbated
acervate1336983acervate_
aceta74017353aceta___
acetal84314903aceta__l
acetamid1344793acetamid
acetamides1543603acetamides
acetamids1443443acetamids
acetifies1447133acetifies
acetins9313173acet_ins
acetone9310793acetone_
acetose938843acetose_
acetous9410363acet_ous
acetylate1444213acetylate_
acetylated1643163acetylated
acetyls12285353acet_yls
achiotes1339003achiotes
acierate10311813acierate_
acierated1238283acierated
acolytes13168043acolytes
aconites10314353aconites
acreages1138373acreages
acrylates1446683acrylates
activates1449683activates
actives12311523ac_tives
actuate9311443actuate_
actuated1138743actuated
acuate8315633ac_uate_
acutances1345763acutances
acutes83917723ac__utes
acylate12310533acylate_
acylated1437873acylated
adulates9311913adulates
aerate64830553a_erate_
aerated85322373a_erated
agates76121343a__gates
agemate101210583agemate_
agitate8312063agitate_
agitated1038413agitated
agnates82813193a_gnates
airdates939723airdates
alates64833963a__lates
alienates9310683alienates
ameerates1149063ameerates
amesaces1246693amesaces
amirates101114793amirates
amputates1345263amputates
anatases839793anatases
animates101316423animates
annates72415423a_nnates
annotates977293annotates
anteater8311603anteater
anteaters939343anteaters
antedates1048613antedates
apatites10311293apatites
apetalies1148003apetalies
apostates1149163apostates
appetites1347513appetites
arenites8917103arenites
aretes64425353are__tes
ariettes8411353ariet_tes
arsenates979373arsenates
asperates11312553asperates
averages1249183averages
aviates10313063a_viates
backdates1848153backdates
berates94126873_berates
betakes134212523_betakes
cantatas103410093cantatas
carates95630613_carates
caretakes1547143caretakes
cartages11313313cartages
caseates10313713caseates
casemates1349523casemates
casettes1039653caset_tes
castrates11312673castrates
catenates11311813catenates
cates75951893_c__ates
caudates11310263caudates
cavitates14168963cavitates
ceases84427073_ce_ases
cenotes92814543_cenotes
centares102913893_centares
cerastes101111093_cerastes
cerate84829463_cerate_
cerated103922473_cerated
cerites94823433_cerites
certes84623083_ce_rtes
cetane8315283_cetane_
cetes75731103_ce__tes
chelates132713843chelates
citrates102315093_citrates
comates114123643_comates
crates85736063_c_rates
creates95225203_creates
cremates124216003cremates
curates95323833_curates
debates103718533_debates
delates83526283_delates
derates84028893_derates
dictates11311383dictates
ecotages1136973ecotages
ectases92911673ec_tases
edentates1046953edentates
elates65032363__elates
elevates111110423elevates
enates64026433__enates
estates74520183_estates
etapes85415293__etapes
faceplates1744613faceplates
facetted1445743facet_ted
galettes93111153galet_tes
gazettes18296863gazet_tes
gelates83219583_gelates
gestates93213733gestates
hebetates1446433hebetates
hectares1338853hectares
ideates8313733ide_ates
imitates10310503imitates
instates81615833instates
iterates81317823iterates
jaculates182810363jaculates
lacerate102214703lacerate_
lacerated122210673lacerated
lactases1038513lac_tases
lactate9312693lac_tate_
lactated1138863lac_tated
layettes1136263layet_tes
legates82917683_legates
macerate122314073macerate_
macerated142010523macerated
macerater13259523macerater
maceraters14226633maceraters
maculates132013723maculates
makebates1744973makebates
maleates103316343male_ates
metages102714973_metages
metate82720533_metate_
mutates92215793_mutates
navettes1136613navet_tes
negates83215843_negates
nictates1039593nictates
notates72817483_notates
nutates73214973_nutates
octanes91111393oc_tanes
octaves12316963oc_taves
octettes1045533octettes
oleates7417833ole_ates
operates10515413operates
palettes103112833palet_tes
pectases122411193pectases
pectate112214693pectate_
penates93321603_penates
petites93820203_petites
phenates13611583phenates
predates11615813predates
prelates10418573prelates
pretapes122811533pretapes
pretastes11119423pretastes
racemate1239063racemate_
raclettes1147013raclet_tes
rebates95123183_rebates
recrates102420373recrates
redates83423873_redates
relates73731433_relates
remates93827113_remates
restates83423433restates
retakes113718863_retakes
retapes93917423_retapes
retastes82212903_retastes
retaxes143615093_retaxes
rotates72819773_rotates
sanitates9611733sanitates
scutages1136503scutages
scutate9310323scutate_
sedates83418043_sedates
senates73322613_senates
spectates13228813spectates
states64337083__states
tates55444983___tates
tectites1039993tectites
testates83615453testates
tractates1159763trac_tates
triacetates1373403triacetates
ulcerates1148853ulcerates
unstates81314993unstates
upstates10189643upstates
vacates12312833vac__ates
valerates12310543valerates
vegetates1346403vegetates

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.470380193.6
2DLD Change Limit1461622236.79621507.1
3Display Results2232230.0932397.8
 (SQL Overall)1786912237.35924282.0
 
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.