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

392 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
marlite9291708(None) 
marline93320971marline
marlites103415271marlites
marmite112413991marmite
aplite8316392_aplite
barite84224812bar_ite
carline93923622carline
halite93624232ha_lite
haplite12310702haplite
malate84624562ma_late
malice104818482ma_lice
maline84529092ma_line
manlike133012782manlike
mannite9312902mannite
maplike15299272maplike
marine84230412mar_ine
marlier92614782marlier
marlin84220912marli_n
marlines103818732marlines
marling103322772marling
marlins93420482marlins
marlitic1238342marlitic
marmites122212792marmites
mullite9313012mullite
oarlike113411192oarlike
partite9317132partite
pearlite1039442pearlite
perlite9317322perlite
uralite71714102uralite
warlike142410472warlike
ablate82219213_ablate
aerolite8315053aerolite
airlike11310333airlike
airline7315033airline
alate55340333_a_late
albite8313313_albite
alike95523963_a_like
aline57243153_a_line
alit46155693_a_lit_
alive85722513_a_live
amosite9313163amosite
amrita8411133amr_ita
aplites9314933_aplites
arbiter939933_arbiter
arbute8311043_arbute
arenite71017713_arenite
arete56031353_ar_ete
arise56436433_ar_ise
armlike1348553_armlike
arrive91311793_arrive
arsine64021043_arsine
artiste73813693_artiste
augite7312613_augite
axite125218253_a_xite
axlike17388853_axlike
baglike14338943baglike
bailie83818363baili_e
bakelite1447253bakelite
ballute938543ballute
barbate11314543barbate
barbie105018353barbi_e
barites94322333bar_ites
barmie103816393barmi_e
barnlike1437183barnlike
baryte115312883bar_yte
batlike133311883batlike
bauxite1635573bauxite
bearlike14156793bearlike
berline93716853berline
blite76225353__blite
bornite9311183bornite
burkite1337003burkite
calcite11413783calcite
carate84734003car_ate
carbide126112493carbide
carbine112918643carbine
cardiae10713713cardiae
caribe103416753car_ibe
carle74535703carl__e
carlin84421823carli_n
carlines103521663carlines
carling103727063carling
carlins93921923carlins
carlish12312773carlish
carmine112918483carmine
carnie84421093carni_e
carte75940423car__te
catlike132712933catlike
cauline92215603cauline
cerite84724873cer_ite
charlie123011923charli_e
cordite10315263cordite
curite85222943cur_ite
dacite91115883da_cite
darkie113714013darki_e
darling93418363darling
daylit10512493daylit_
earlier72612743earlier
earlobe946553earlobe
egalite8311563egalite
elite56230183__elite
fadlike15318483fadlike
fanlike142610503fanlike
farcie114816473farci_e
farle86929243farl__e
farolito1155583farolito
farside1138603farside
fatlike142911193fatlike
fayalite1447053fayalite
ferlie92814053ferli_e
ferrite103312753ferrite
flite85424963__flite
gahnite1135973gahnite
gallate83417133gallate
garlic9310043garli_c
garlics1038013garlics
garote7717953gar_ote
garotte868703garotte
garpike1435093garpike
garrote8510113garrote
gaslit7513503gaslit_
girlie73711463girli_e
granite82017083granite
hairlike1536673hairlike
hairline1137873hairline
halide103417993ha_lide
halites103221193ha_lites
haplites1339993haplites
hardline12310273hardline
harelike1539613harelike
harlot94422803harlot_
harlots103413293harlots
harmine122816193harmine
hatlike143311713hatlike
hoplite12311073hoplite
hyalite13229473hyalite
illite63414923_illite
impolite1249293impolite
iolite63221983_iolite
jadeite1546403jadeite
jamlike20126923jamlike
jarosite1548383jarosite
jawlike21116003jawlike
jawline17137063jawline
kainite1149543kainite
kaoline11310143kaoline
karate105320923kar_ate
kernite1159473kernite
lardlike1336503lardlike
larine63927043lar_ine
lawlike14137073lawlike
lazulite1745033lazulite
lite47054543___lite
machete14310883machete
machine14313493machine
macle96127003macl__e
maculate122815623maculate
magnate10512703magnate
magpie1139093magpi_e
maile75232223ma__ile
mailing102923343mailing
mainline1039863mainline
maize164618563ma__ize
malaise9312673malaise
malates93522613ma_lates
male66052303ma_l__e
maleate94117543maleate
malgre9299303ma_lgre
malic94525663ma_li_c
malices114316623ma_lices
malign939853ma_lign
malines93625613ma_lines
mallee84525593ma_llee
mallet84433053mallet_
mallets93318493mallets
malling103623663malling
maloti8313213ma_loti
malt66254813ma_l_t_
malted94819863ma_l_ted
maltier93015483ma_ltier
malts76331753ma_l_ts
malty106721703ma_l_ty
mamie95826003ma_mi_e
mammate104411273mammate
mammie94313783mammi_e
mandate10315573mandate
manille92613273manille
manito8518693ma_nito
manitu8315823ma_nitu
manlier92414023manlier
manlily1238743manlily
mannites10312613mannites
manwise1239183manwise
maple95521143mapl__e
maranta9311693maranta
marbelize2246113marbelize
marble104219103mar_ble
marbleise1343483marbleise
marbleize2243073marbleize
marblier1256343marblier
marbling13179883marbling
marcasite1346663marcasite
marcato1139743marcato
marchlike2044793marchlike
mare64759333mar___e
maremme1054603maremme
margarite1247513margarite
marge85328333mar__ge
margin94016853margi_n
marginate12179603marginate
margined1237753margined
margins103815193margins
maria75032883mar_i_a
marina84623413mar_ina
marinate103017783marinate
mariner93316003mar_iner
marines93928023mar_ines
marish114319053mar_ish
marital92314183mar_ital
maritime1247383maritime
market123226043market_
marketed1537323marketed
marketer1437383marketer
markets133314033markets
marking144020133marking
marl66341623marl___
marled95523163marl_ed
marliest102415183marliest
marlings113713503marlings
marls75535163marl__s
marlstone1144593marlstone
marly106925613marl__y
marmot10318743marmot_
marmots11311513marmots
marplot1149673marplot_
marplots1245633marplots
marque172410503mar_que
marquee18218583marquee
marquise19206173marquise
marriage1147253marriage
married104715303married
marrier93817523marrier
marries93825283marries
marring103319553marring
marse76231153mar__se
marshlike1843903marshlike
mart66865983mar__t_
marted94425213mar__ted
marten84518263mar__ten
martial92415413martial
martian93514683martian
martin84122523marti_n
martinet10319653martinet
marting103325013marting
martini93613873martini
martins93322063martins
martlet93419153martlet_
martlets103310483martlets
marts77442233mar__ts
mashie11315933mashi_e
masklike1335593masklike
masonite1049683masonite
massive12289773massive
mastlike1437863mastlike
mate65154223ma___te
matelote1047603matelote
matte75626843ma__tte
mauling103315683mauling
mavie104722563ma_vi_e
maximite1955853maximite
maxixe1435223ma_xixe
mazelike2336463mazelike
mealie82519813meali_e
melilite10410573melilite
merit7339183mer_it_
merited10313853mer_ited
merits8320873mer_its
merle75824373merl__e
merlin83916683merli_n
merlins93015813merlins
merlot83217613merlot_
merlots92710123merlots
midlife13248303midlife
midline102315103midline
millime112511403millime
milline92519113milline
mirliton1044183mirliton
miscite11314383miscite
mislie83219153misli_e
mislike132914833mislike
mislit83019693mislit_
mislive122812693mislive
mite66249413m___ite
moatlike1446993moatlike
moline84422033m_oline
mollie83517103molli_e
moraine9314573moraine
moralise10314913moralise
morality131110333morality
moralize19313923moralize
mortice11711493mortice
mortise9713533mortise
mullites10411643mullites
muriate9313363muriate
murine84220023mur_ine
murrine9411483murrine
myeline1238253myeline
nardine82712573nardine
nargile847653nargile
narine63422553nar_ine
narrate7313493narrate
natrolite948023natrolite
norite63221133nor_ite
oaklike10268003oaklike
oatlike113412403oatlike
oolite63319603_oolite
orality101111683orality
palate84226793pa_late
palliate10311893palliate
parakite14410423parakite
parasite10314843parasite
pardie96021443pardi_e
pardine103616723pardine
parity114719873par_ity
parklike1337493parklike
parlante1039693parlante
parle75836163parl__e
parling103823763parling
partita9310863partita
parvise124211693parvise
pearlites1138233pearlites
pelite84323003_pelite
penlite9313243penlite
perlites10316363perlites
polite83625073_polite
praline93019743praline
purline93516533purline
pyrite11913313pyr_ite
ralline73518413ralline
rarity93615493rar_ity
ratite65022423ra_tite
ratlike113912353ratlike
ratline74517803ratline
raylike14269253raylike
rite45849453__r_ite
ruralite848963ruralite
saclike131210123saclike
saline65132703sa_line
saltie63422433sa_ltie
salute64418023sa_lute
samite83020603sa_mite
saprolite1147833saprolite
sardine83317393sardine
sawlike14138443sawlike
smaltite1046903smaltite
smartie9310173smarti_e
sparlike1437673sparlike
sprite84421773spr_ite
starlike1238813starlike
starlit71512913starlit_
stylite10219613stylite
taglike12278913taglike
tagline82412453tagline
tallit63422733tallit_
tallith102913063tallith
tallits73215993tallits
tardive1136893tardive
taxite13511303ta_xite
tergite8311003tergite
termite9313893termite
tillite7313563tillite
trite54730033_tr_ite
turgite837973turgite
umangite1144823umangite
uralites82112723uralites
uranite72515693uranite
valine94623093va_line
valise92917643va_lise
vallate103016563vallate
variate101316433variate
variolite1248083variolite
varlet9423503varlet_
varlets10411573varlets
varsity1356673varsity
verite94323443ver_ite
wallie93216803walli_e
wartime1237743wartime
wartlike1537043wartlike
waxlike21185973waxlike
write85522833_wr_ite
zaratite1747793zaratite
zeolite1638903zeolite

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.390458182.1
2DLD Change Limit1340273926.81319672.2
3Display Results3923920.1402800.0
 (SQL Overall)1786913927.34324334.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.