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

299 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
marmite11241399(None) 
marlite92917071marlite
marmites122212791marmites
barite84224812bar_ite
barmie103816392barmi_e
carmine112918482carmine
harmine122816192harmine
mamie95826002ma_mi_e
mammate104411272mammate
mammie94313782mammi_e
mannite9312902mannite
marine84230402mar_ine
marline93320952marline
marlites103415262marlites
marmot10318742marmot_
marmots11311512marmots
maximite1955852maximite
partite9317132partite
samite83020602sa_mite
termite9313892termite
admire949933_admire
admit8319493_admit_
admits9411413_admits
albite8313313_albite
amice96122873_a_mice
amide86128483_a_mide
amie66339853_a_mi_e
amine75835383_a_mine
amity10416093_a_mity
ammine10314493_ammine
amosite9313163amosite
amrita8411133amr_ita
aplite8316393_aplite
arbiter939933_arbiter
arbute8311043_arbute
arenite71017713_arenite
arete56031353_ar_ete
arise56436433_ar_ise
armet76739453_armet_
armets84918353_armets
armies85123693_armies
armiger1036253_armiger
arming94719803_arming
armlet84118193_armlet
armlike1348553_armlike
armoire938133_armoire
armpit10811093_armpit_
armpits1157133_armpits
armure8710133_armure
arrive91311793_arrive
arsine64021043_arsine
artiste73813693_artiste
augite7312613_augite
axite125218253_a_xite
barbate11314543barbate
barbie105018353barbi_e
barites94322333bar_ites
barmier114313043barmier
baryte115312883bar_yte
bauxite1635573bauxite
bornite9311183bornite
burkite1337003burkite
calamite12312533calamite
calcite11413783calcite
camise103319633ca_mise
cammie124615293cammi_e
carate84734003car_ate
carbide126112493carbide
carbine112918643carbine
cardiae10713703cardiae
caribe103416753car_ibe
carline93923613carline
carmines123617863carmines
carnie84421093carni_e
carte75940423car__te
catamite12510593catamite
cerite84724873cer_ite
chromite15310833chromite
cordite10315263cordite
curite85222943cur_ite
dacite91115883da_cite
dammit11311133dammit_
darkie113714013darki_e
dormice1237133dormice
dormie9312623dormi_e
eremite9312833eremite
ermine8416923_ermine
famine114318193fa_mine
farcie114816473farci_e
farming133515083farming
farmwife1942173farmwife
farside1138603farside
fermate122813003fermate
ferrite103312753ferrite
fomite113314073_fomite
formate123115093formate
furmity1535183furmity
gahnite1135973gahnite
gamete9313593ga_mete
gamine94620153ga_mine
garote7717953gar_ote
garotte868703garotte
garpike1435093garpike
garrote8510103garrote
granite82017083granite
gummite1236133gummite
halite93624233ha_lite
hamate113319833ha_mate
haplite12310703haplite
harmin113117393harmi_n
harmines132715143harmines
harming133717933harming
harmins123716723harmins
hermit11519443hermit_
hermits12312143hermits
imamate1138103ima_mate
jadeite1546403jadeite
jarosite1548383jarosite
jasmine1636643jasmine
kainite1149543kainite
karate105320923kar_ate
karmic1438113karmi_c
kernite1159473kernite
lamiae84817453la_miae
larine63927043lar_ine
machete14310883machete
machine14313493machine
magmata1237463magmata
magnate10512703magnate
magpie1139093magpi_e
maile75232223ma__ile
maiming122912723maiming
maize164618563ma__ize
malaise9312673malaise
malamute1245893malamute
malate84624553ma_late
maleate94117543maleate
malemute1244923malemute
malice104818483ma_lice
maline84529083ma_line
malmier113611953malmier
mamies104626243ma_mies
mammae94613213ma_mmae
mammati10398373mammati
mammee94417853ma_mmee
mammet94319253mammet_
mammets103911113mammets
mammies104314763mammies
mammitis1145593mammitis
mammoth1344983mammoth
mandate10315573mandate
manito8518693ma_nito
manitu8315823ma_nitu
manlike133012783manlike
manmade1237963manmade
mannites10312613mannites
manumit1149573manumit_
manumits1246003manumits
manwise1239183manwise
maplike15299273maplike
maranta9311693maranta
marble104219103mar_ble
marcasite1346663marcasite
marcato1139743marcato
mare64759333mar___e
maremme1054603maremme
margarite1247513margarite
marge85328333mar__ge
margin94016843margi_n
marginate12179603marginate
margined1237743margined
margins103815193margins
maria75032883mar_i_a
marimba1354983marimba
marina84623413mar_ina
marinate103017783marinate
mariner93315993mar_iner
marines93928013mar_ines
marish114319053mar_ish
marital92314183mar_ital
maritime1247383maritime
market123226043market_
marketed1537323marketed
marketer1437383marketer
markets133314033markets
marking144020133marking
marlier92614773marlier
marlin84220903marli_n
marlines103818713marlines
marling103322763marling
marlins93420473marlins
marlitic1238343marlitic
marmoset12411983marmoset
marque172410503mar_que
marquee18218583marquee
marquise19206173marquise
marriage1147253marriage
married104715303married
marrier93817523marrier
marries93825283marries
marring103319553marring
marse76231153mar__se
mart66865983mar__t_
marted94425213mar__ted
marten84518263mar__ten
martial92415413martial
martian93514683martian
martin84122523marti_n
martinet10319643martinet
marting103325013marting
martini93613873martini
martins93322063martins
martlet93419153martlet
marts77442233mar__ts
mashie11315933mashi_e
masonite1049683masonite
massive12289773massive
mate65154223ma___te
matte75626843ma__tte
maumet103518883maumet_
maumets11369693maumets
mavie104722563ma_vi_e
maximise1944913maximise
maximites2045313maximites
maximize2844573maximize
maxixe1435223ma_xixe
merit7339183mer_it_
merited10313853mer_ited
merits8320873mer_its
miscite11314383miscite
mismate111415353mismate
mite66249413___mite
moraine9314573moraine
mortice11711493mortice
mortise9713533mortise
mullite9313013mullite
muriate9313363muriate
murine84220023mur_ine
murrine9411483murrine
nardine82712573nardine
nargile847653nargile
narine63422553nar_ine
narrate7313493narrate
norite63221133nor_ite
oarlike113411193oarlike
palmate113215233palmate
parakite14410423parakite
parasite10314843parasite
pardie96021443pardi_e
pardine103616723pardine
parity114719873par_ity
partita9310863partita
parvise124211693parvise
pearlite1039443pearlite
perlite9317323perlite
permit10321683permit_
permits11314003permits
permute1138793permute
psammite1442983psammite
pyrite11913313pyr_ite
ramate83921683ra_mate
ramie75027823ra_mi_e
rarity93615493rar_ity
ratite65022423ra_tite
rearmice1255213rearmice
rite45849453__r_ite
samites93118713sa_mites
sardine83317393sardine
smaltite1046903smaltite
smarmier1235033smarmier
smarmily1543523smarmily
smartie9310173smarti_e
smite75224873__smite
somite84519373_somite
sprite84421773spr_ite
surmise9311083surmise
tammie104212693tammi_e
tardive1136893tardive
taxite13511303ta_xite
tergite8311003tergite
termites10313693termites
thermite1339033thermite
trite54730033_tr_ite
turgite837973turgite
umangite1144823umangite
uralite71714103uralite
uranite72515693uranite
variate101316433variate
varmint12311683varmint
varmints1335643varmints
varsity1356673varsity
verite94323443ver_ite
warlike142410473warlike
warming133515083warming
warmish1538373warmish
warmth1477933warm_th
wartime1237743wartime
write85522833_wr_ite
zaratite1747793zaratite

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.406440125.6
2DLD Change Limit1340272996.93619323.4
3Display Results2992990.1102718.2
 (SQL Overall)1786912997.45223978.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.