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

369 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
marlites10341526(None) 
marlines103818711marlines
marlite92917071marlite_
marmites122212791marmites
aplites9314932_aplites
barites94322332bar_ites
carlines103521652carlines
halites103221192ha_lites
haplites1339992haplites
malates93522612ma_lates
malices114316622ma_lices
malines93625602ma_lines
mannites10312612mannites
marines93928012mar_ines
marlier92614772marli_er
marliest102415182marli_est
marline93320952marline_
marlings113713492marlings
marlins93420472marli_ns
marlitic1238342marlitic
marmite112413992marmite_
marries93825282marri_es
mullites10411642mullites
pearlites1138232pearlites
perlites10316362perlites
uralites82112722uralites
ablates92416903_ablates
aerolites9312583aerolites
airlines8312793airlines
alates64833973_a_lates
albites9313203_albites
alines65735223_a_lines
allies63827673_alli_es
amosites10311233amosites
amritas939093amr_itas
aplite8316393_aplite_
arbiter939933_arbiter
arbiters1038853_arbiters
arbutes939703_arbutes
arenites8917103_arenites
aretes64425353_ar_etes
arises65233803_ar_ises
arles56735743_arl__es
armies85123693_armi_es
arrises71617583_arrises
arrives101311513_arrives
arsines73518813_arsines
artistes83213343_artistes
ascites9312603_ascites
augites8312183_augites
axites134913833_a_xites
bailies94120203baili_es
bakelites1545993bakelites
ballies93725743balli_es
ballutes1037523ballutes
barbies114519593barbi_es
barflies1338303barfli_es
barite84224813bar_ite_
barytes124611153bar_ytes
bauxites1735153bauxites
berlines102315453berlines
blites84721213__blites
bornites10310983bornites
burkites1436673burkites
calcites12313003calcites
calices114321693ca_lices
carates95630613car_ates
carbides133111693carbides
carbines123617543carbines
carditis11310233carditis
caribes113715643car_ibes
carices114220953car_ices
caries85147623car_i_es
caritas93316963car_itas
carles85435083carl__es
carline93923613carline_
carlings114015863carlings
carlins93921923carli_ns
carmines123617873carmines
carnies94123963carni_es
carries94328013carri_es
cartes86239473car__tes
cerites94823433cer_ites
charlies133414233charli_es
cordites11314623cordites
curites93919863cur_ites
dacites101114593da_cites
dailies84219263daili_es
dallies84023193dalli_es
darbies104216983darbi_es
darkies124015753darki_es
darlings103710383darlings
earlier72612743earli_er
earliest82415243earli_est
earliness939693earliness
earlobes1056143earlobes
egalites9310503egalites
elites66027123__elites
farcies125317883farci_es
farles96025783farl__es
farolitos1244053farolitos
farsides1237993farsides
fayalites1546063fayalites
ferlies103216693ferli_es
ferrites112312833ferrites
flites95122443__flites
frites94922483_fr_ites
gahnites1235703gahnites
gallates92815533gallates
gallies84122713galli_es
garlics1038013garli_cs
garotes8614563gar_otes
garottes978283garottes
garpikes1534373garpikes
garrotes969363garrotes
girlies83013703girli_es
granites92116363granites
hairlines1237133hairlines
halides113416663ha_lides
halite93624233ha_lite_
halitus10339963ha_litus
haplite12310703haplite_
hardies114923233hardi_es
harlots103413293harlot_s
harmines132715143harmines
harpies123818323harpi_es
harries103525493harri_es
hoplites13310543hoplites
hurlies103315333hurli_es
hyalites14208833hyalites
illites72415013_illites
iolites73819483_iolites
jadeites1645823jadeites
jarosites1647373jarosites
jawlines18126363jawlines
kainites1238793kainites
kaolines1239293kaolines
karates115617473kar_ates
kernites1269113kernites
lazulites1844253lazulites
machetes1539633machetes
machines15312893machines
macles107023223macl__es
maculates132013723maculates
magnates11511613magnates
magpies12310363magpi_es
mailes84329113ma__iles
mailings113011923mailings
mainlines1138513mainlines
maizes175115733ma__izes
malaises10312333malaises
malate84624563ma_late_
maleates103316343maleates
males75049793ma_l__es
malice104818483ma_lice_
maligns1038133ma_ligns
maline84529083ma_line_
mallees93315973ma_llees
mallets93318493mallet_s
mallings113413093mallings
malted94819863ma_l_ted
malteds10377603ma_l_teds
maltier93015483ma_ltier
maltiest102916193ma_ltiest
malts76331753ma_l_t_s
mamies104626243ma_mi_es
mammies104314763mammi_es
mammitis1145593mammitis
mandates11314093mandates
manilles102312603manilles
manitos9314053ma_nitos
manitus9310923ma_nitus
manlier92414023manli_er
manliest102314943manli_est
manlike133012783manlike_
manliness111310123manliness
mannite9312903mannite_
mantes84430783ma__ntes
mantises10317923mantises
maples104819423mapl__es
maplike15299273maplike_
marantas10310023marantas
marbelizes2345373marbelizes
marbleises1443523marbleises
marbleizes2342943marbleizes
marbles114516653mar_bles
marblier1256343marbli_er
marbliest1336763marbli_est
marblings14225543marblings
marcasites1445623marcasites
marcatos1249163marcatos
marches143921173mar_ches
mares76457633mar___es
margarites1346533margarites
marges94525713mar__ges
marginates13168743marginates
margined1237743margined
margins103815193margi_ns
marinas93519393mar_inas
marinates112516383marinates
marine84230403mar_ine_
mariner93315993mar_iner
mariners103113863mar_iners
marishes13512553marishes
marital92314183mar_ital
marketed1537323marketed
marketer1437383marketer
marketers1545983marketers
markets133314033market_s
markings153410243markings
marled95523163marl__ed
marlin84220903marli__n
marling103322763marli_ng
marls75535163marl___s
marlstones1244513marlstones
marmots11311513marmot_s
marplots1245633marplot_s
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
martlets103310483martlet_s
marts77442233mar__t_s
mashies12318253mashi_es
masonites1149173masonites
mastitis1039103mastitis
mastixes1738253mastixes
matelotes1146333matelotes
mates75251363ma___tes
matrices12312083matrices
matrixes1738063matrixes
mattes85624533ma__ttes
mavies114923193ma_vi_es
mavises122812993ma_vises
maximites2045313maximites
maxixes1535253ma_xixes
mayflies1644913mayfli_es
mealies92821933meali_es
melilites1149193melilites
mercies113817563merci_es
merises93421423mer_ises
merited10313853mer_ited
merits8320873mer_it_s
merles85322763merl__es
merlins93015813merli_ns
merlots92710123merlot_s
midlines112613333midlines
midlives14287463midlives
millimes122411373millimes
millines102718063millines
mirliton1044183mirliton
mirlitons1144113mirlitons
miscites12313783miscites
mislies92922283misli_es
mislikes143311833mislikes
mislives132912153mislives
mites75141803m___ites
molies84429513m_oli_es
mollies93420233molli_es
moraines10314363moraines
moralises11314003moralises
moralities121111923moralities
moralizes20312863moralizes
morrises10711073morrises
mortices12711563mortices
mortises10713613mortises
muhlies1238933muhli_es
mullite9313013mullite_
muriates10312083muriates
murices112612283mur_ices
murines93718223mur_ines
murries94118673murri_es
myelines1337123myelines
myelitis1345113myelitis
nargiles976793nargiles
narrates8312763narrates
natrolites1047413natrolites
norites74018803nor_ites
oarlike113411193oarlike_
oolites72817843_oolites
oralities91214123oralities
palates93624943pa_lates
palliates11311033palliates
parakites1549543parakites
parasites11313153parasites
paries84742513par_i_es
parietes10714543parietes
parises94827183par_ises
parities10522973par_ities
parles86334403parl__es
parries93925843parri_es
parties93230863parti_es
partitas10310253partitas
partite9317133partite_
parvises133911913parvises
pearlite1039443pearlite_
pelites93821993_pelites
penlites10312273penlites
perlite9317323perlite_
pralines102217723pralines
purlines103514053purlines
pyrites12812203pyr_ites
rallies73823343ralli_es
rarities8316333rar_ities
ratites74920683ra_tites
ratlines83815293ratlines
rites54442553__r_ites
ruralites947943ruralites
salines74029413sa_lines
sallies73227813salli_es
salties73725773sa_lties
salutes73716253sa_lutes
samites93118713sa_mites
saprolites1247053saprolites
sardines92815573sardines
smaltites1145743smaltites
smarties10312873smarti_es
sorites73825243sor_ites
sprites94220333spr_ites
stylites11168693stylites
taglines92210833taglines
talipes9611603ta_lipes
tallies73624603talli_es
tallises82713263tallises
tallithes12286583tallithes
talliths11377433talliths
tallits73215993tallit_s
tardies84225863tardi_es
tarries73324263tarri_es
taxites1449673ta_xites
tergites9310543tergites
termites10313693termites
tillites8312833tillites
turgites937783turgites
umangites1244483umangites
uralite71714103uralite_
uranites82514643uranites
valines104520213va_lines
valises103516263va_lises
variates111214983variates
varices123313573var_ices
varies94330873var_i_es
variolites1346673variolites
varlets10411573varlet_s
varsities1239243varsities
velites103417303_velites
verites103822263ver_ites
walies95324523wa_li_es
wallies103320743walli_es
warlike142410473warlike_
wartimes1336963wartimes
writes94420333_wr_ites
yearlies1137603yearli_es
zaratites1847003zaratites
zeolites1738383zeolites

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 Filter1786911461620.453394461.4
2DLD Change Limit1461623697.29620033.2
3Display Results3693690.1402635.7
 (SQL Overall)1786913697.88922650.7
 
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.