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

305 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
marmites12221279(None) 
marlites103415261marlites
marmite112413991marmite_
armies85123692_armi_es
barites94322332bar_ites
carmines123617862carmines
harmines132715142harmines
mamies104626242ma_mi_es
mammies104314762mammi_es
mammitis1145592mammitis
mannites10312612mannites
marines93928012mar_ines
marlines103818712marlines
marlite92917072marlite_
marmots11311512marmot_s
marries93825282marri_es
maximites2045312maximites
samites93118712sa_mites
termites10313692termites
admires1038663_admires
admits9411413_admit_s
admixes1765963_admixes
albites9313203_albites
amices105018013_a_mices
amides95722663_a_mides
amies76837693_a_mi_es
amines84727983_a_mines
amities9317383_a_mities
ammines11312673_ammines
amosites10311233amosites
amritas939093amr_itas
aplites9314933_aplites
arbiter939933_arbiter
arbiters1038853_arbiters
arbutes939703_arbutes
arenites8917103_arenites
aretes64425353_ar_etes
arises65233803_ar_ises
armets84918353_armet_s
armiger1036253_armiger
armigers1135703_armigers
armings103811503_armings
armlets94610063_armlets
armoires1057623_armoires
armpits1157133_armpit_s
armures9510273_armures
arrises71617583_arrises
arrives101311513_arrives
arsines73518813_arsines
artistes83213343_artistes
ascites9312603_ascites
augites8312183_augites
axites134913833_a_xites
barbies114519593barbi_es
barite84224813bar_ite_
barmie103816393barmi_e_
barmier114313043barmi_er
barmiest125212783barmi_est
barytes124611153bar_ytes
bauxites1735153bauxites
bornites10310983bornites
burkites1436673burkites
calamites13410713calamites
calcites12313003calcites
camises114218463ca_mises
cammies134016483cammi_es
carates95630613car_ates
carbides133111693carbides
carbines123617533carbines
carditis11310223carditis
caribes113715643car_ibes
carices114220953car_ices
caries85147623car_i_es
caritas93316953car_itas
carlines103521643carlines
carmine112918483carmine_
carnies94123963carni_es
carries94328013carri_es
cartes86239473car__tes
catamites1349363catamites
cerites94823433cer_ites
chromites16310963chromites
cordites11314623cordites
curites93919863cur_ites
dacites101114593da_cites
darbies104216983darbi_es
darkies124015753darki_es
dermises112512023dermises
eremites10312603eremites
ermines9416673_ermines
famines123216263fa_mines
farcies125317883farci_es
farmings14298223farmings
farmwives2041783farmwives
farsides1237993farsides
ferrites112312833ferrites
fomites123613203_fomites
formates132814293formates
frites94922483_fr_ites
furmities1447543furmities
gahnites1235703gahnites
gametes10312253ga_metes
gamines103618463ga_mines
garotes8614563gar_otes
garottes978283garottes
garpikes1534373garpikes
garrotes969363garrotes
granites92116363granites
gummites1346173gummites
halites103221193ha_lites
hamates122917683ha_mates
haplites1339993haplites
hardies114923233hardi_es
harmine122816193harmine_
harmins123716723harmi_ns
harpies123818313harpi_es
harries103525493harri_es
hermits12312143hermit_s
imamates1237663ima_mates
jadeites1645823jadeites
jammies183611293jammi_es
jarosites1647373jarosites
jasmines1736623jasmines
kainites1238793kainites
karates115617473kar_ates
kermises14248313kermises
kernites1269113kernites
limites92915453_limites
machetes1539633machetes
machines15312893machines
magnates11511613magnates
magpies12310363magpi_es
mailes84329113ma__iles
maizes175115733ma__izes
malaises10312333malaises
malamutes1345373malamutes
malates93522603ma_lates
maleates103316343maleates
malemutes1344453malemutes
malices114316623ma_lices
malines93625603ma_lines
malmier113611953malmi_er
malmiest123211023malmi_est
mamboes135011823ma_mboes
mameyes14376983ma_meyes
mamie95826003ma_mi_e_
mammate104411273mammate_
mammatus1144233mammatus
mammees104411143ma_mmees
mammets103911113mammet_s
mammie94313783mammi_e_
mammitides1442763mammitides
mammoths1442853mammoths
mandates11314093mandates
manitos9314053ma_nitos
manitus9310923ma_nitus
mannite9312903mannite_
mantes84430783ma__ntes
mantises10317923mantises
manumits1246003manumit_s
marantas10310023marantas
marbles114516653mar_bles
marcasites1445623marcasites
marcatos1249163marcatos
marches143921173mar_ches
mares76457633mar___es
margarites1346533margarites
marges94525713mar__ges
marginates13168743marginates
margined1237743margined
margins103815193margi_ns
marimbas1444363marimbas
marinas93519383mar_inas
marinates112516383marinates
marine84230403mar_ine_
mariner93315993mar_iner
mariners103113863mar_iners
marishes13512553marishes
marital92314183mar_ital
marketed1537323marketed
marketer1437383marketer
marketers1545983marketers
markets133314033market_s
markings153410243markings
marlier92614773marli_er
marliest102415183marli_est
marline93320953marline_
marlings113713493marlings
marlins93420473marli_ns
marlitic1238343marlitic
marmoset12411983marmoset
marmosets1344833marmosets
marmot10318743marmot__
marquees19206243marquees
marques182610863mar_ques
marquises20225703marquises
marriages1247383marriages
married104715303marri_ed
marrieds11288073marrieds
marrier93817523marri_er
marriers103312473marriers
marses84827113mar__ses
marshes123615373mar_shes
marted94425213mar__ted
marten84518263mar__ten
martens93714953mar__tens
martians103111613martians
martinet10319643martinet
martinets1138883martinets
martinis103311613martinis
martins93322063marti_ns
martlets103310483martlets
marts77442233mar__t_s
mashies12318253mashi_es
masonites1149173masonites
mastitis1039103mastitis
mastixes1738253mastixes
mates75251363ma___tes
matrices12312083matrices
matrixes1738063matrixes
mattes85624533ma__ttes
maumets11369693maumet_s
mavies114923193ma_vi_es
mavises122812993ma_vises
maximises2044873maximises
maximite1955853maximite_
maximizes2944403maximizes
maxixes1535253ma_xixes
mercies113817563merci_es
merises93421423mer_ises
merited10313853mer_ited
merits8320873mer_it_s
miscites12313783miscites
mismates121114563mismates
mites75141803___mites
mommies103912273mommi_es
moraines10314363moraines
morrises10711073morrises
mortices12711563mortices
mortises10713613mortises
mullites10411643mullites
mummies103812843mummi_es
muriates10312083muriates
murices112612283mur_ices
murines93718223mur_ines
murries94118673murri_es
nargiles976793nargiles
narrates8312763narrates
norites74018803nor_ites
panmixes1934913panmixes
parakites1549543parakites
parasites11313153parasites
paries84742513par_i_es
parietes10714543parietes
parises94827183par_ises
parities10522973par_ities
parries93925843parri_es
parties93230863parti_es
partitas10310253partitas
partite9317133partite_
parvises133911913parvises
pearlites1138233pearlites
perlites10316363perlites
permits11314003permit_s
permutes1238713permutes
psammites1542843psammites
pyrites12812203pyr_ites
ramies84630463ra_mi_es
rarities8316333rar_ities
ratites74920683ra_tites
rites54442553__r_ites
samite83020603sa_mite_
sardines92815563sardines
smaltites1145743smaltites
smarmier1235033smarmi_er
smarmiest1335903smarmi_est
smarminess1444303smarminess
smarties10312873smarti_es
smites83921923__smites
somites94219123_somites
sorites73825243sor_ites
sprites94220333spr_ites
surmises10310643surmises
tamises92715973ta_mises
tammies113814683tammi_es
tardies84225863tardi_es
tarries73324263tarri_es
taxites1449673ta_xites
tergites9310543tergites
termite9313893termite_
thermites1438043thermites
turgites937783turgites
umangites1244483umangites
uralites82112723uralites
uranites82514643uranites
variates111214983variates
varices123313573var_ices
varies94330873var_i_es
varmints1335643varmints
varsities1239243varsities
verites103822263ver_ites
warmths1583783warm_ths
wartimes1336963wartimes
writes94420333_wr_ites
zaratites1847003zaratites

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.420425454.8
2DLD Change Limit1461623057.47019566.5
3Display Results3053050.1262420.6
 (SQL Overall)1786913058.01622291.8
 
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.