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

216 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
mammate10441127(None) 
mammae94613211mamma_e
mammati10398371mammati
gemmate12418382gemmate
hamate113319832ha_mate
imamate1138102ima_mate
magmata1237462magmata
magnate10512702magnate
malate84624562ma_late
maleate94117542maleate
mamma86317912mamma__
mammal95112752mamma_l
mammals10389272mammals
mammary1335992mammary
mammas94616402mamma_s
mammatus1144232mammatus
mammee94417852mamm_ee
mammet94319252mammet_
mammets103911112mammets
mammie94313782mamm_ie
mammoth1344982mammoth
mandate10315572mandate
manmade1237962manmade
marmite112413992marmite
mismate111415352mismate
palmate113215232palmate
ramate83921692ra_mate
summate113611662summate
teammate1245612teammate
abate76627843_a_bate
ablate82219213_ablate
acuate8315633_acuate
adnate72913483_adnate
aerate64830553_aerate
agate66525153_a_gate
agemate101210583agemate
agnate73314883_agnate
alate55340333_a_late
amaze166016603_a_maze
ambage11510603_ambage
amirate91115953amirate
ammeter1148393_ammeter
ammine10314493_ammine
animate91617213animate
ansate64517863_ansate
aurate64426473_aurate
aviate9315203_aviate
baccate131011263baccate
bandmate1347973bandmate
barbate11314543barbate
basmati1148233basmati
bedmate1239433bedmate
bromate11313553bromate
cammie124615293camm_ie
carate84734003ca_rate
caseate9314783caseate
casemate1239843casemate
caudate10311353caudate
climate11312833climate
comate104124843_comate
commata1338483commata
commute134310443commute
cremate113816183cremate
damage10410783da_mage
dammar11438903damma_r
dammars12308193dammars
dammit11311133dammit_
daymare1375633daymare
emaciate1248753emaciate
emanate9312473ema_nate
falcate12311623falcate
fermate122813003fermate
flatmate1346393flatmate
formate123115093formate
galeate83916793galeate
gallate83417133gallate
gambade1336383gambade
gamete9313593ga_mete
gamma106116103gamma__
gammas115714693gamma_s
gemmae11507793gemma_e
gemmated14336293gemmated
gemmates13307673gemmates
gummata1244613gummata
gummite1236133gummite
hamates122917683ha_mates
hammada1545093hammada
hammal134512063hamma_l
hammals14409233hammals
hammam12419333hamma_m
hammams13386443hammams
hamulate1359013hamulate
hastate10313913hastate
hazmat20312263hazmat_
hazmats2136603hazmats
humate113214443_humate
imamates1237663ima_mates
immane1038883_immane
inmate82917363_inmate
jammable2144513jammable
karate105320923ka_rate
labiate91313573labiate
lactate9312703lactate
lambaste12145013lambaste
lamiae84817453lamia_e
laminate103014633laminate
lanate6421263la_nate
lemmata1144673lemmata
limbate1139213limbate
macerate122314073macerate
machete14310883machete
macrame1338713macrame
maculate122815623maculate
madame1139853ma_dame
madman113712383madma_n
magma104513573magma__
magmas115512503magma_s
magmatic1548403magmatic
magnates11511613magnates
makebate1645063makebate
malamute1245893malamute
malates93522613ma_lates
maleates103316343maleates
malemute1244923malemute
maltase938903maltase
mama86231593ma_ma__
mamas95930773ma_ma_s
mamba116317523mamba__
mambas125716243mamba_s
mamie95826003ma_m_ie
mammality1544283mammality
mammees104411143mammees
mammer94218863mamm_er
mammered12237653mammered
mammers104615693mammers
mammey124310893mamm_ey
mammeys13376723mammeys
mammies104314763mammies
mammitis1145593mammitis
mammock1664393mammock
mammon939643mamm_on
mammons1048513mammons
mammoths1442853mammoths
mammy115215163mamm__y
manage93818903ma_nage
manat76039993ma_nat_
manatee9317663ma_natee
manats84623463ma_nats
mandated12310293mandated
mandates11314093mandates
mannite9312903mannite
mapmaker1864373mapmaker
marcato1139743marcato
marinate103017783marinate
marlite92917073marlite
marmites122212793marmites
marmot10318743marmot_
marmots11311513marmots
massage1039893massage
mate65154223___mate
matte75626843ma__tte
maturate10312623maturate
maumet103518883maumet_
maumets11369693maumets
maximite1955853maximite
mediate103415213mediate
messmate1246393messmate
metate82720533m_etate
miasmata1244503miasmata
migrate101314173migrate
misate81222693m_isate
misdate101413963misdate
mismade12129353mismade
mismake15139373mismake
mismated131111333mismated
mismates121114563mismates
misrate91319143misrate
momma85111053momma__
mommas94110653momma_s
muriate9313363muriate
mutate83017483m_utate
myomata1445923myomata
narrate7313493narrate
palate84226793pa_late
paleate94120003paleate
palmated132511003palmated
palpate113213923palpate
playmate1566463playmate
plumate1149803plumate
primate111516283primate
psammite1442983psammite
racemate1239063racemate
radiate83416313radiate
rampage1237453rampage
remate84428683_remate
roommate1244863roommate
rummage1234583rummage
saccate111311763saccate
samite83020603sa_mite
satiate7315403satiate
savate9313783sa_vate
seatmate1048573seatmate
sigmate10710143sigmate
stomate9313123stomate
summae103911013summa_e
summated13298833summated
summates122610493summates
tamale83717403ta_male
tammie104212693tamm_ie
tannate71813523tannate
teammates1345673teammates
vacate11314553va_cate
vallate103016563vallate
valuate102512733valuate
valvate133710813valvate
variate101316433variate

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.423422437.4
2DLD Change Limit1340272166.98319193.3
3Display Results2162160.0802700.0
 (SQL Overall)1786912167.48623870.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.