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

173 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
areolate8101445(None) 
areolae7811731areola_e
areolated1089711areolated
aerolite8315052aerolite
alveolate1244412alveolate
apholate13410472apholate
areola6813672areola__
areolar779222areola_r
areolas71013862areola_s
areole61017282areol__e
arillate8412992arillate
arrogate91210322arrogate
aureolae845312aureola_e
faveolate15104622faveolate
prelate9519692pre_late
prolate9419792pr_olate
reflate103516262_reflate
relate64033632_re_late
replate93420052_replate
reslate73520592_reslate
urceolate1143732urceolate
variolate1248552variolate
ablate82219213a__blate
abrogate11129603abrogate
absolute1044483absolute
accolade1346053accolade
acerate92818913ace_rate
acerbate1247533acerbate
acervate1336983acervate
acetate92514753ace_tate
acetylate1444213acetylate
acolyte12157653a_colyte
acrylate1347693acrylate
acylate12310533a_cylate
adequate1844303adequate
adulate8313233a_dulate
advocate1445833advocate
aerate64830553a_e_rate
aerobat9514473aerobat_
aerobats1049843aerobats
aerolites9312583aerolites
aerolith1149833aerolith
aeroplane1146593aeroplane
aerosat7417183aerosat_
aerosats8411013aerosats
agemate101210583age_mate
alate55340333a___late
aldolase944773aldolase
alkylate1554663alkylate
allocate10411023allocate
ambulate1239733ambulate
ameerate1039633ameerate
angulate9312013angulate
annotate877713annotate
annulate8310923annulate
anolyte10159003a_nolyte
apholates1449683apholates
appellate1346193appellate
arcuate9311963ar_cuate
areae55229743are__a_e
arecoline1147103arecoline
arenite71017713are_nite
areoles71016953areol_es
areology1237383areology
arete56031353are___te
aristate8312133aristate
arrogated11147143arrogated
arrogates10129423arrogates
arsenate81010483arsenate
aureate72515283aure__ate
aureola747033aureola__
aureolas846853aureola_s
aureole738693aureol__e
automate10411943automate
avellane1146273avellane
bardolater1343843bardolater
baseplate13114873baseplate
bregmate1345533bregmate
bromate11313553br_omate
carbonate13410513carbonate
carpellate1445333carpellate
chelate122914903che_late
cholate122114933_cholate
corelate10516013core_late
create85126383cre__ate
cremate113816183cre_mate
crenate93317113cre_nate
crenelate1176513crenelate
crenulate1167693crenulate
creole8913733creol__e
creolise1037863creolise
creolize1947183creolize
creosote1045923creosote
crewmate15405633crewmate
cryolite1347503cryolite
dealate83617843_dealate
deflate113613943_deflate
delate73827753_de_late
derogate10311353derogate
desolate9411993desolate
elate55335883__e_late
etiolate849523etiolate
faceplate1645223faceplate
fellate10313433_fellate
folate93320393__folate
foveolate15104293foveolate
gelate73421263_ge_late
immolate1246543immolate
insolate8311893insolate
isolate7313923_isolate
kryolite1544493kryolite
labellate11126933labellate
lamellate11116713lamellate
lanceolate1253213lanceolate
lineolate946283lineolate
nameplate1344613nameplate
neonate7311333_neonate
ocellate1037873ocellate
overlate11716283overlate
patellate1147483patellate
percolate13411163percolate
perorate10417923perorate
phenolate1447493phenolate
predate10616893pre_date
preflame1545913preflame
prelates10418573pre_lates
prelocate13109523prelocate
preplace1488983preplace
priorate10411733priorate
probate11414483pr_obate
pronate9418873pr_onate
prorate9418733pr_orate
rebate84424113_re_bate
reclame11411063_reclame
recrate92621663_recrate
redate74124683_re_date
reflated123514293_reflated
reflates113115663_reflates
regelate9312083_regelate
reglaze1747223_reglaze
regrate82618663_regrate
regulate9313023_regulate
relace83122153_re_lace
related83327573_re_lated
relater73723143_re_later
relates73731433_re_lates
relocate10713533_relocate
remate84428683_re_mate
remolade1147203_remolade
renovate1138553_renovate
replace113214283_replace
replated112817523_replated
replates102919273_replates
replete92912993_replete
reslated93517523_reslated
reslates83619503_reslates
resolute868513_resolute
resonate8513513_resonate
restate73824883_restate
reviolate1248123_reviolate
revolute1176793_revolute
rotate63320343_r_otate
solate64526073__solate
stellate8310503stellate
toeplate1047613toeplate
tremolite1156893tremolite
vacuolate1445223vacuolate
variolated1445403variolated
variolates1347463variolates
variolite1248083variolite
velate93720143_ve_late
violate10311553_violate
zeolite1638903_zeolite

Search took 9 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.466383457.1
2DLD Change Limit1461621738.14017956.0
3Display Results1731730.0632746.0
 (SQL Overall)1786911738.66920612.6
 
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.