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

345 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
acerate9281891(None) 
acerated113113981acerated
acerbate1247531acerbate
acervate1336981acervate
acetate92514751acetate
acierate10311811acierate
aerate64830551a_erate
cerate84829461_cerate
lacerate102214701lacerate
macerate122314071macerate
accrete1137842accrete
accurate12410662accurate
acerbated1465552acerbated
acerbates1347252acerbates
acerose9310892acerose
acetated112010682acetated
acetates102013062acetates
acierated1238282acierated
acierates11310792acierates
acreage1037832acreage
actuate9311442actuate
acuate8315632ac_uate
acylate12310532acylate
aerated85322372a_erated
aerates74627482a_erates
agemate101210582agemate
ameerate1039632ameerate
amirate91115952amirate
asperate10312372asperate
aurate64426472a_urate
aureate72515282aureate
average1158852average
berate84729022_berate
carate84734002_carate
cerated103922472_cerated
cerates95428232_cerates
cerite84724872_cerite
crate76537402_c_rate
create85126372_create
curate85226242_curate
derate74531232_derate
iterate71119102iterate
lacerated122210672lacerated
lacerates112413762lacerates
macerated142010522macerated
macerater13259522macerater
macerates132113562macerates
ocreate93711742ocreate
operate9615732operate
overate10620962overate
racemate1239062racemate
recrate92621642recrate
ulcerate1039732ulcerate
valerate11311462valerate
abate76627843a__bate
aberrated1245873aberrated
ablate82219213a_blate
ablegate1147253ablegate
abnegate1144863abnegate
abrade9313053a_brade
acarine9316003acarine
acaudate1145973acaudate
accelerate1444903accelerate
accreted1336333accreted
accretes1238113accretes
accrue1035823accr_ue
acerb9312763acer__b
acerber1135233acerber
acerbic1335643acerbic
acerbity1544273acerbity
acerola947823acerola
acerous9513333acerous
aceta74017353ace__ta
acetal84314903aceta_l
acetals93411353acetals
acetone9310793acetone
acetose938843acetose
acetylate1444213acetylate
achiote1239213achiote
acolyte12157643acolyte
aconite9315473aconite
acre67330773ac_r__e
acreages1138363acreages
acrylate1347693acrylate
activate13510373activate
actuated1138743actuated
actuates10310303actuates
aculeate1039913aculeate
acute74720363ac__ute
acylated1437863acylated
acylates1339743acylates
adequate1844303adequate
adnate72913483a_dnate
adulate8313233adulate
aerator7314843a_erator
aerie54634603a_er_ie
aerobe8412403a_erobe
agate66525143a__gate
agemates111110023agemates
ageratum1143463ageratum
aggrade1035633aggrade
agitate8312063agitate
agnate73314873a_gnate
agorae7511203agora_e
agrafe1038093a_grafe
airdate8311323airdate
alate55340323a__late
alert54740653aler_t_
alerted82512223aler_ted
alerter72111513aler_ter
alerts64418223aler_ts
alienate8311553alienate
aliterate91611323aliterate
altercate1147853altercate
alternate948113alternate
amebae1049633ameba_e
ameerates1149043ameerates
amerce10310513amer_ce
amesace1147733amesace
amirates101114793amirates
amperage1347743amperage
animate91617213animate
ankerite1248923ankerite
ansate64517863a_nsate
antedate949683antedate
aortae65115473a_ortae
apyrase1236363apyrase
arame75026623a__rame
arcuate9311963arcuate
areae55229743are_a_e
arenite71017713arenite
areolate81014453areolate
arete56031353a__rete
arsenate81010483arsenate
ascorbate1344463ascorbate
asperated1239313asperated
asperates11312543asperates
aspirate1039943aspirate
attrite7311833attrite
aurae54128113a_ura_e
aurated83817793a_urated
averaged1356213averaged
averages1249183averages
averse95811183aver_se
avert86029493aver_t_
averted112211613aver_ted
averter102410553aver_ter
averts95715243aver_ts
aviate9315203a_viate
azurite1638003azurite
baccate131011263bac_cate
backdate1748223backdate
berake124216083_berake
berated104422133_berated
berates94126853_berates
borate85026153_borate
calcarate1347703calcarate
calceate1239863calce_ate
camerae11312043camera_e
carafe115416163_carafe
carat75048793_carat_
carates95630603_carates
carats85929023_carats
carte75940423_car_te
caseate9314783caseate
casemate1239843casemate
castrate10313863castrate
cate66254593_c__ate
catenate10312833catenate
caudate10311353caudate
cease75227653_ce_ase
cenote83715843_cenote
cerastes101111093_cerastes
ceratin93020163_ceratin
cere66741473_cer__e
cerise84822043_cerise
cerites94823433_cerites
cermet10321153_cermet
certes84623083_cer_tes
ceruse83914523_ceruse
cetane8315283_cetane
cete64934783_ce__te
chelate122914893chelate
cirrate92413483cirrate
citrate92216793citrate
coacervate1763713coacervate
cocreate122611813cocreate
comate104124843_comate
cordate10315213_cordate
crake114823523_c_rake
crane75331603_c_rane
crape96128443_c_rape
crated94827773_c_rated
crater85026633_c_rater
crates85736053_c_rates
crave105626313_c_rave
craze165221463_c_raze
crease85519573_crease
created104323443_created
creates95225173_creates
cremate113816183cremate
crenate93317113crenate
curare84916953_curare
curated104717583_curated
curates95323823_curates
curite85222943_curite
curtate9312643_curtate
deaerate9314163deaerate
debate94419193_debate
decorate11315193decorate
delate73827753_delate
derat65044083_derat_
derated93623503_derated
derates84028883_derates
derats74625063_derats
disrate81418523disrate
ecarte84313503ecar_te
elate55335883__elate
elevate101110373elevate
emeerate10410093emeerate
emirate91015833emirate
enate54428143__enate
enervate1148453enervate
erase54925493__erase
ergate7315143__ergate
exacerbate21113373exacerbate
execrate1739643execrate
faceplate1645223faceplate
facete115014833face__te
federate12310873federate
fermate122813003_fermate
ferrate103014033ferrate
galeate83916783gale_ate
gelate73421253_gelate
generate9312893generate
grate64932883__grate
gyrate104912523_gyrate
hydrate14239813hydrate
ideate7313683ide_ate
increate10312203increate
ingrate8715113ingrate
irate55627983__irate
iterated91213813iterated
iterates81317813iterates
jaculate172311783jaculate
karate105320923_karate
lacerable1346943lacerable
lacerative1556283lacerative
lactate9312693lac_tate
lacunate10128963lacunate
laterite8716333laterite
laureate888023laureate
layerage1244963layerage
legate72917453_legate
liberate101113383liberate
librate93214233librate
literate81216883literate
lyrate94112103_lyrate
maceraters14226633maceraters
macerator13217633macerator
macrame1338713mac_rame
maculate122815623maculate
makebate1645063makebate
maleate94117543male_ate
maturate10312613maturate
metate82720533_metate
migrate101314163migrate
misrate91319143misrate
moderate11710993moderate
narrate7313493narrate
negate72915573_negate
nervate1039523_nervate
nitrate72017013nitrate
numerate101610393numerate
ocellate1037863ocellate
ocreae83310273ocrea_e
oleate6318883ole_ate
operated11512223operated
operates10515403operates
orate55133303__orate
outrate72323183outrate
overage11514053overage
overawe13511463overawe
overhate14312793overhate
overlate11716283overlate
overrate11615683overrate
paleate94120003pale_ate
pectate112214693pectate
pedate93117763_pedate
peerage1089803peerage
phenate12412193phenate
phorate12413363phorate
picrate112014143picrate
pirate82322883_pirate
prate75135983__prate
predate10616893predate
prelate9519693prelate
prerace11414123prerace
prorate9418733prorate
racemates1348853racemates
rate45458763___rate
rebate84424103_rebate
recrated112918583recrated
recrates102420353recrates
recreate10313603recreate
redate74124683_redate
regrate82618653regrate
relate64033633_relate
remate84428683_remate
saccate111311763sac_cate
saturate8312813saturate
sclerae937933sclera_e
sclerite10410713sclerite
scrape105917573sc_rape
scutate9310323scutate
secrete9311073secrete
sedate73019803_sedate
senate63725143_senate
serape84818413_serape
seriate73722473_seriate
serrate73017533serrate
stearate839713stearate
tartrate899673tartrate
terete6319333_terete
ternate7415483_ternate
thecate123210023thecate
titrate72215573titrate
tolerate8312323tolerate
ulcerated1247743ulcerated
ulcerates1148843ulcerates
uncrate9415953uncrate
uncreate10311353uncreate
underate9918603underate
uprate83916543_uprate
urate55432163__urate
vacate11314553vac__ate
valerates12310533valerates
velate93720143_velate
venerate11312893venerate
verite94323443_verite
verste94515633_verste
vibrate122811513vibrate
vicarate1378603vicarate
waterage1248663waterage
yperite1249893yperite

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.310576422.6
2DLD Change Limit1340273456.84619577.4
3Display Results3453450.1232804.9
 (SQL Overall)1786913457.27924548.8
 
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.