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

207 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
agemate10121058(None) 
agemates111110021agemates
acerate92818912acerate
acetate92514752acetate
aerate64830552a_erate
agamete1037402agamete
agate66525152ag__ate
agitate8312062agitate
agnate73314882ag_nate
animate91617212animate
casemate1239842casemate
cremate113816182cremate
gelate73421262_gelate
gemmate12418382_gemmate
gemote94613022_gemote
racemate1239062racemate
remate84428682_remate
abate76627843a__bate
ablate82219213a_blate
ablegate1147253ablegate
abnegate1144863abnegate
acerated113113983acerated
acerbate1247533acerbate
acervate1336983acervate
acetated112010683acetated
acetates102013063acetates
acierate10311813acierate
actuate9311443actuate
acuate8315633a_cuate
acylate12310533acylate
adequate1844303adequate
adnate72913483a_dnate
adulate8313233adulate
aerated85322373a_erated
aerates74627493a_erates
agama85815583agama__
agamas97413453agama_s
agametes1147293agametes
agapae9388043agapa_e
agape85614843ag__ape
agates76121343ag__ates
agave95314033ag__ave
agaze156113663ag__aze
agee56241493age___e
ageist7315383ageist_
ageists848493ageists
agene65621583age__ne
agenize172910153agenize
agent65829643age_nt_
agented939423age_nted
agents74816293age_nts
ageratum1143463ageratum
aggrade1035643aggrade
aggregate1244203aggregate
agitated1038413agitated
agitates9310883agitates
agitato856573agitato
aglare7312433ag_lare
agma77623263ag_ma__
agmas85919873ag_ma_s
agminate1139243agminate
agnates82813193ag_nates
agorae7511203agora_e
agrafe1038093ag_rafe
aguacate1144973aguacate
airdate8311323airdate
alate55340333a__late
alginate9310693alginate
alienate8311553alienate
amaze166016603a__maze
amebae1049633ameba_e
ameerate1039633ameerate
amesace1147733amesace
amirate91115953amirate
anemone9119453anemone
angulate9312013angulate
animated111612373animated
animater101512393animater
animates101316423animates
animato91610623animato
ansate64517863a_nsate
antedate949693antedate
arcuate9311963arcuate
areae55229743are_a_e
arenite71017713arenite
areolate81014453areolate
arete56031353are__te
arsenate81010483arsenate
asperate10312373asperate
aurate64426473a_urate
aureate72515283aureate
automate10411943automate
average1158853average
aviate9315203a_viate
axeman1538103axema_n
bandmate1347973bandmate
bedmate1239433bedmate
bemata10411693_bemata
berate84729023_berate
bregmate1345533bregmate
bromate11313553bromate
caseate9314783case_ate
casemated1446953casemated
casemates1349523casemates
catenate10312833catenate
cerate84829463_cerate
chelate122914893chelate
climate11312833climate
comate104124843_comate
copemate1439993copemate
create85126383cre_ate
cremated133412963cremated
cremates124216003cremates
crenate93317113crenate
crewmate15405633crewmate
debate94419193_debate
delate73827753_delate
demote94817803_demote
derate74531233_derate
edemata1046003edemata
elate55335883__elate
elevate101110373elevate
emote75421193__emote
enate54428153__enate
enemata948013enemata
eremite9312833eremite
female11310553_female
fermate122813003fermate
formate123115093formate
galeate83916793galeate
gallate83417133gallate
gamete9313593_gamete
gate55746573_g__ate
gelated93615643_gelated
gelates83219593_gelates
gelati73814533_gelati
gelato73812963_gelato
geminate11411813_geminate
gemmae11507793_gemmae
gemmated14336293_gemmated
gemmates13307673_gemmates
gemot84024233_gemot_
gemotes103712143_gemotes
gemots93712153_gemots
germane1049663_germane
gestate83614073_gestate
geste65920693_ge_ste
grate64932883_g_rate
gyrate104912523_gyrate
hamate113319833_hamate
humate113214443_humate
ideate7313683ide_ate
imamate1138103imamate
inmate82917363_inmate
iterate71119113iterate
lacerate102214713lacerate
legate72917453_legate
macerate122314073macerate
magmata1237463mag_mata
magnate10512703mag_nate
makebate1645063makebate
maleate94117543male_ate
malemute1244923malemute
mammate104411273mammate
mate65154223___mate
metate82720533_metate
mismate111415353mismate
negate72915573_negate
oleate6318883ole_ate
operate9615733operate
overate10620963overate
paginate114012443paginate
paleate94120003pale_ate
palmate113215233palmate
pedate93117763_pedate
phenate12412203phenate
plumate1149803plumate
predate10616893predate
prelate9519693prelate
premade12311443premade
primate111516283primate
racemates1348853racemates
ramate83921693_ramate
rebate84424113_rebate
redate74124683_redate
regelate9312083regelate
regmata1036193regmata
regrate82618663regrate
relate64033633_relate
remade94316983_remade
remake124016113_remake
remated103522473_remated
remates93827113_remates
remote84222603_remote
sedate73019813_sedate
senate63725173_senate
sigmate10710143sigmate
stalemate1146643stalemate
stomate9313123stomate
summate113611663summate
tablemate1344833tablemate
thecate123210023thecate
vaginate123911083vaginate
valerate11311473valerate
vegetate1246673vegetate
velate93720143_velate
yokemate1744313yokemate

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.406440125.6
2DLD Change Limit1340272075.90622693.4
3Display Results2072070.0762723.7
 (SQL Overall)1786912076.38827972.9
 
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.