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

534 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
mariners10311386(None) 
mariner93316001mariner_
marines93928021marine_s
aliners74717722_aliners
briners94315632_briners
darners83815772dar_ners
drainers92811252drainers
earners74016452ear_ners
gainers84214592ga_iners
garners83815992gar_ners
grainers93012072grainers
imaginers1243692imaginers
loriners839962loriners
mailers94420332ma_ilers
maimers113813042ma_imers
maligners12104782maligners
malines93625612maline_s
malingers1285852malingers
manners93417832ma_nners
marblers12319232marblers
marchers153710812marchers
marinara1046492marinara
marinaras1145562marinaras
marinas93519392marin_as
marine84230412marine__
markers133516102mar_kers
marlines103818732marline_s
marrers93414312mar_rers
marriers103312472marriers
martinets1138882martinets
matinees102110422matinees
matiness102114752matiness
maziness19239542maziness
miners84126632m__iners
miriness10310462miriness
murines93718222murine_s
pardners11269192pardners
partners102711132partners
trainers83114642trainers
variers103712662vari_ers
wariness11313212wariness
warners103315562war_ners
yarners104312202yar_ners
abiders104011083_abiders
acarines10314343acarine_s
aginners954623_aginners
aiders74524633_a_iders
aimers84621913_a_imers
airers64922313_a_irers
airiness8412223airiness
airliners945983airliners
aivers94822323_a_ivers
alieners889823_alieners
aligners9117573_aligners
aliner65621983_aliner_
alines65735223_aline_s
almners9399563_almners
amarones10311353amarone_s
amines84727983_amine_s
ammines11312673ammine_s
arbiters1038853_arbiters
archers124414573_archers
arenes64928393_arene_s
arguers8489033_arguers
arider74717743_arider_
aridness939233_aridness
ariels65119373_ari_els
arises65233803_arise_s
armers85520273_ar_mers
armigers1135703_armigers
arrivers11137003arrivers
arsines73518823_arsine_s
artiness81615413_artiness
atoners75013963_atoners
azines155517073_azine_s
bailers94221353ba_ilers
baiters94619313ba_iters
banners94018713ba_nners
barbers114317503bar_bers
bareness10912813bareness
bargainers1343873bargainers
barites94322333barite_s
barkers134318513bar_kers
barneys12569563bar_neys
barnier93213673barnier_
baroness101210063baroness
baronets101410913baronets
barriers104311893barriers
barters94223043bar_ters
basinets1039063basinets
biners85023633__biners
braiders114110573braiders
branners104010923branners
bribers114111503_bribers
briers85319733_bri_ers
briner84519043_briner_
brines85028853_brine_s
bringers112811073_bringers
buriers94017193buri_ers
burners94115673bur_ners
byliners1334753byliners
cabinets1238283cabinets
caginess11310303caginess
cahiers123510673cahi_ers
cakiness1449553cakiness
calibers1238523calibers
calipers1249443calipers
caners84629203ca__ners
canines93724033canine_s
canners93822663ca_nners
carabiners1445073carabiners
carbineers1444233carbineers
carbines123617543carbine_s
carders104820353car_ders
careeners1138553careeners
careers95218783car_eers
carers85133963car__ers
caribes113715643caribe_s
carices114220953carice_s
caries85147623cari_e_s
carinas93622413carin_as
carlines103521663carline_s
carmines123617873carmine_s
carnets93918403car_nets
carneys124310543car_neys
carnies94123963carnie_s
carolers103314173carolers
carpers114521253car_pers
carriers103614203carriers
carters95327253car_ters
carvers124817543car_vers
cavilers1348113cavilers
chariness14310063chariness
clarinets1137683clarinets
coiners93620753_coiners
corners94723313cor_ners
coroners104016233coroners
criers83918583_cri_ers
cringers112511873_cringers
daikers124010313da_ikers
damners104112113da_mners
darers75921873dar__ers
darings93713653darin_gs
darkeners1435163darkeners
darkness13247343darkness
darnels83710433dar_nels
darner74017303dar_ner_
darters84017603dar_ters
definers124211193definers
deriders102411853deriders
deringers1137183deringers
derivers123811363derivers
diners75525953__diners
diviners12308353diviners
drainer83012843drainer_
driers74516733_dri_ers
drinkers13277823_drinkers
drivers114412793_drivers
droners84114383_droners
earings84517713earin_gs
earliness939693earliness
earner63617223ear_ner_
easiness8313043easiness
eeriness8311873eeriness
eloiners8128153eloiners
examiners18124433examiners
fainer94717243fa_iner_
fainters11349693fa_inters
fairness1136563fairness
famines123216263famine_s
fanners103914653fa_nners
farcers124713443far_cers
farers95924053far__ers
farinas103215243farin_as
farinhas14325363farinhas
farmers124315263far_mers
farness102912203far_ness
farriers113610743farriers
fawners13388493fa_wners
friers94718933_fri_ers
frizers19329553_frizers
furriners12316323furriners
gainer74117493ga_iner_
gaiters83516543ga_iters
gamines103618463gamine_s
gaminess112911063gaminess
garblers113810283garblers
gardeners1136613gardeners
garglers10418263garglers
garner73917003gar_ner_
garnets84115413gar_nets
garters84218243gar_ters
glariness1038553glariness
goriness9310753goriness
grainer83714063grainer_
grinders103410423_grinders
grinners9288043_grinners
gripers104011463_gripers
hagriders1443553hagriders
hailers104017263ha_ilers
hairiness1238013hairiness
hairnets1195633hairnets
harbingers1643943harbingers
hardeners1338093hardeners
hardiness132310363hardiness
hardness122411083hardness
harkeners1636083harkeners
harmers124116593har_mers
harmines132715143harmine_s
harness102413933har_ness
harpers124916203har_pers
harriers113712433harriers
haziness20248513haziness
hoariness1238823hoariness
imaginer1144303imaginer_
imagines1137463imagine_s
imprinters1444143imprinters
ironers74813553_ironers
jailers144114043ja_ilers
jarinas143712193jarin_as
joiners144211573_joiners
kaisers11369273ka_isers
karabiners1642693karabiners
laciness102112553laciness
lanners73618333la_nners
larceners1136003larceners
larders83516943lar_ders
larine63927043larine__
larkers113014513lar_kers
larkiness1338113larkiness
latrines8515013latrine_s
lawines103313563lawine_s
laziness17239983laziness
learners8398153lear_ners
liners65428853__liners
lorimers1036613lorimers
loriner7511893loriner_
macers105321273ma__cers
machinery1943093machinery
machines15312893machine_s
madders113513213ma_dders
madness10310073ma_dness
madrones112912283madrone_s
magisters1235803magisters
magnets10311143ma_gnets
maidens10349663ma_idens
maihems1444303ma_ihems
mailer84724183ma_iler_
mailes84329113ma_ile_s
maimer104514593ma_imer_
mainliners1244003mainliners
mains75635113ma_in__s
mairs76228303ma_i__rs
maizes175115733ma_ize_s
makers123921733ma__kers
makings145413163makin_gs
malanders1237023malanders
maleness10312313maleness
malices114316623malice_s
maligner11115333maligner_
maline84529093maline__
malinger11116533malinger_
maltiness112910573maltiness
mamies104626243mami_e_s
mammers104615693ma_mmers
mamzers20409163ma_mzers
managers112911003managers
manes76648963ma__ne_s
mangers103521263ma_ngers
manginess122010413manginess
manglers113311903manglers
manliness111310123manliness
manner84020513ma_nner_
manors84420883ma__nors
manurers1037593manurers
mappers133313783ma_ppers
marantas10310023marantas
marauders1244263marauders
marbler113511673marbler_
marbles114516653marble_s
marcels113212373mar_cels
marcher143912973marcher_
marches143921173marche_s
mares76457633mar__e_s
margents11410133margents
marges94525713mar_ge_s
marginals1246013marginals
margined1237753margine_d
margins103815193margin__s
marimbas1444363marimbas
marina84623413marin__a
marinade11259383marinade
marinades12268973marinades
marinate103017783marinate
marinates112516383marinates
marishes13512553marishes
marker124420393mar_ker_
marketers1545993marketers
markets133314033mar_kets
markhors1745393markhors
markings153410243markin_gs
marlier92614783marlier_
marline93320973marline__
marlings113713503marlin_gs
marlins93420483marlin__s
marlites103415273marlite_s
marmites122212793marmite_s
marquees19206243marquees
marques182610863marque_s
marquess19204953marquess
marrer83716673mar_rer_
marrieds11288073marrieds
marrier93817523marrier_
marries93825283marrie_s
marses84827113mar_se_s
marshes123615373marshe_s
marshiness1555063marshiness
martens93714953mar_tens
martinet10319653martine_t
martinis103311613martin_is
martins93322063martin__s
martlets103310483martlets
martyrs1234893mar_tyrs
marvels123810093mar_vels
masers84623453ma__sers
mashers124621053ma_shers
maskers133913843ma_skers
masquers19195703masquers
massiness112810143massiness
masters94628923ma_sters
matchers153012433matchers
maters85032393ma__ters
matier84321523mati_er_
matinee92415613matine_e
matings104516213matin_gs
matins84527783matin__s
matrices12312083matrice_s
matrixes1738063matrixe_s
matters94421753ma_tters
maturers1037383maturers
maulers94213303ma_ulers
maunders11348343maunders
mavies114923193mavi_e_s
mavins115119183mavin__s
mavises122812993mavise_s
maxixes1535253maxixe_s
mayings134410513mayin_gs
mazers173917093ma__zers
mazier175013063mazi_er_
mealiness11310063mealiness
meaners94415243m_eaners
meatiness11311183meatiness
mercers114412773mer_cers
mergers103813423mer_gers
merinos9311983merin_os
merises93421423merise_s
merriness1138293merriness
metiers93312843meti_ers
milers84625163m__ilers
milliners11289953milliners
mimers105520183m__imers
mincers113714853m__incers
minders103720123m__inders
miner76933543m__iner_
mines75651953m__ine_s
minivers1337483minivers
minors85117103m__inors
minters93822473m__inters
mirier83918363miri_er_
mirins83918903mirin__s
misers85025703m__isers
misinfers1445483misinfers
misinters1138183misinters
miters84328783m__iters
mixers154513563m__ixers
moaners92813553m_oaners
moilers93615203m_oilers
monikers1437413monikers
mooners94015343m_ooners
mopiness12259063mopiness
moraines10314363moraine_s
moreness10911573moreness
mortisers1186173mortisers
motioners1146583motioners
mourners1036913mourners
murders103311363mur_ders
murices112612283murice_s
murine84220023murine__
murkiness15206293murkiness
murthers1336543murthers
mutineers1144633mutineers
mutines93117823mutine_s
nailers73215893na_ilers
narine63422553narine__
painters103013023pa_inters
paniers94717333pani_ers
panners93621273pa_nners
panniers10488853panniers
paraders113113113paraders
parceners1337463parceners
pardner10239473pardner_
pardoners12208213pardoners
parers85530743par__ers
paries84742513pari_e_s
parings104219213parin_gs
parises94827183parise_s
parkers133816873par_kers
parriers103612903parriers
parsers94118153par_sers
partiers103514243partiers
partner92811393partner_
partyers13277763partyers
patines95225763patine_s
pavisers13387443pavisers
pawners124311073pa_wners
praisers103410833praisers
prawners1346003prawners
pricers113915063_pricers
priers84521193_pri_ers
primers114215673_primers
prinkers143010383_prinkers
printers103214903_printers
prizers183911843_prizers
pruners93710723_pruners
purines94420763purine_s
raciness102413453raciness
raiders84615143ra_iders
railers74420663ra_ilers
raisers73617393ra_isers
rapiers95012873rapi_ers
rapines95120863rapine_s
rareness81112853rareness
ratines75328583ratine_s
raveners11309133raveners
ravines104220233ravine_s
refiners114713313refiners
repiners103913433repiners
ricers84120993__ricers
riders74123903__riders
rimers84522553__rimers
ringers83922953__ringers
rinsers73815743__rinsers
risers64624783__risers
rivers94626543__rivers
ruiners74213023_ruiners
sabines94318483sabine_s
sailers73822323sa_ilers
salines74029413saline_s
sardines92815573sardine_s
sarins63932623sarin__s
sarsnets836783sarsnets
satinets8311733satinets
savines104417633savine_s
scariness11310183scariness
scribers12307963scribers
seiners74219273_seiners
serines74229543serine_s
shiners104015943_shiners
shrines104618693shrine_s
shrinkers16205383shrinkers
shrivers14419103shrivers
smarminess1444303smarminess
smartness1136143smartness
sorners73416873sor_ners
springers12309983springers
sprinters11329373sprinters
stainers83212173stainers
strainers9510393strainers
striders94412123striders
strikers123611293strikers
stringers104210653stringers
stripers103911593stripers
strivers113911843strivers
submariners1553223submariners
tacrines10310563tacrine_s
tailers73720183ta_ilers
tanners74018393ta_nners
tardiness10229923tardiness
tarriers83411713tarriers
tarriness9229243tarriness
tarsiers8298533tarsiers
tartiness92112053tartiness
tartness82210133tartness
taurines8310553taurine_s
teariness9310633teariness
thrivers14456823thrivers
trailers82912923trailers
trainees82712063trainees
trainer73316793trainer_
triers64321523_tri_ers
trimers94615143_trimers
trines64132563_trine_s
turners73912893tur_ners
twiners10459633_twiners
uprisers10206773uprisers
uprivers13215563uprivers
urines64724123_urine_s
vahines133410523vahine_s
vainer93714573va_iner_
valines104520213valine_s
vanners103612843va_nners
varices123313573varice_s
varier94619353vari_er_
varies94330873vari_e_s
veiners104112523_veiners
verniers11227843verniers
wagoners1235473wagoners
wahines133111173wahine_s
wailers103916803wa_ilers
waiters104218623wa_iters
waivers133410053wa_ivers
wakeners1535843wakeners
warblers13319103warblers
warders113416813war_ders
warier93722893wari_er_
warmers124514293war_mers
warmness1337063warmness
warner93717223war_ner_
warpers123413583war_pers
warreners1236203warreners
warslers11328073warslers
waviness1437723waviness
waxiness1836723waxiness
weariness1238843weariness
weiners103913063_weiners
whiners134011573_whiners
wiriness1138953wiriness
wringers123110073_wringers
writers105513493_writers
yarders113211593yar_ders
yarner93313063yar_ner_
yawners13367183ya_wners
yearners11346373year_ners
zaniness1738663zaniness

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.453394461.4
2DLD Change Limit1461625348.09318060.3
3Display Results5345340.2202427.3
 (SQL Overall)1786915348.76620384.6
 
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.