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

537 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
married10471530(None) 
carried103717151carried
harried113815531harried
marred95421041marr_ed
marrieds11288071marrieds
marrier93817521marrier
marries93825281marries
parried103615721parried
tarried83914131tarried
aeried74221862_aeried
arrived11127352_arrived
barred95725792barr_ed
barrier94017732barrier
berried103714042berried
caried94528692ca_ried
carrier93619582carrier
carries94328012carries
curried103313652curried
farrier103514892farrier
ferried113411522ferried
garred85217412garr_ed
harrier104417752harrier
harries103525492harries
herried113514452herried
hurried113511042hurried
jarred144613252jarr_ed
marbled123212112marbled
marched153813402marched
margined1237742margined
marked133921622ma_rked
marled95523162ma_rled
marlier92614772marlier
marrer83716672marr_er
marriers103312472marriers
marring103319552marring
marrowed1445972marrowed
marted94425212ma_rted
merrier92612302merrier
murries94118672murries
parred95024072parr_ed
parrier93717652parrier
parries93925842parries
partied103516552partied
quarried1836092quarried
remarried1244932remarried
serried82513962serried
tarred74720282tarr_ed
tarrier74323172tarrier
tarries73324262tarries
unmarried1244582unmarried
varied104817862va_ried
warred104019842warr_ed
worried11308692worried
acred87126353_acr_ed
acrid86920103_acri_d
aerie54634603_aerie_
aerier64823153_aerier
aeries64737783_aeries
agreed84712503_agreed
aired66032923_air_ed
airier64619363_airier
airted74214503_airted
allied74217153_allied
ambries111614553ambries
amerced1256523amerced
arced88224163_a_rced
arched125717323_arched
arcked136211943_arcked
argled85314553_argled
argued84311173_argued
arid57642713_a_ri_d
ariel55228973_a_riel
ariled75620323_ariled
armed86324433_a_rmed
armies85123693_armies
aroid65428343_aroi_d
arrased8149863_arrased
arrayed11117153_arrayed
arriba867683_arriba
arris56824683_arri_s
arrises71617583_arrises
arrive91311793_arrive
arriver10117793_arriver
arrives101311513_arrives
arrowed1148113_arrowed
artier63419733_artier
babied114913513ba_bied
bandied114414303bandied
barbed115121313ba_rbed
barbie105018353barbie_
barbies114519593barbies
barded105426423ba_rded
bared85144483ba_r_ed
barfed125416383ba_rfed
barged105822643ba_rged
barked135027313ba_rked
barkier133814483barkier
barmie103816393barmie_
barmier114313043barmier
barned95623583ba_rned
barnier93213673barnier
barraged1297683barraged
barre75929543barr_e_
barrel84517873barr_el
barreled1137843barreled
barren85317613barr_en
barres84427543barr_es
barret84930483barr_et
barriers104311883barriers
barring104021593barring
barrio8312573barri_o
barrios9310773barrios
berries94423553berries
birdied11329433birdied
birred94713203birr_ed
buried94822373_buried
burred95820723burr_ed
burrier93613553burrier
caddied123710563caddied
cairned1037643cairned
candied113816023candied
carbide126112493carbide
carded105424903ca_rded
cared86050093ca_r_ed
caries85147623ca_ries
carked134024823ca_rked
carnie84421093carnie_
carnies94123963carnies
caroled103717693caroled
caromed123713623caromed
carped115923763ca_rped
carrel84718633carr_el
carriers103614203carriers
carrion9312673carrion
carromed1338563carromed
carted98631443ca_rted
carved124320853ca_rved
charred134614483charr_ed
charrier1378683charrier
cirriped1344183cirriped
corrie83621233corrie_
corries94026803corries
cried84624283__cried
curred94319263curr_ed
currie84317263currie_
currier93316703currier
curries93723163curries
dairies84217733dairies
daisied93410013daisied
dallied93713613dallied
darbies104216983darbies
dared75935013da_r_ed
darked123919633da_rked
darkie113714013darkie_
darkies124015753darkies
darkled13378723darkled
darned85018483da_rned
darted84620923da_rted
dartled9409853dartled
decried112612853decried
derries83124623derries
dirtied93210853dirtied
dried75321383__dried
durrie73713263durrie_
durries83817353durries
eared65139503ea_r_ed
earlier72612743earlier
earned74818333ea_rned
earring83519013earring
earringed1144453earringed
earthed1139923earthed
embarred13174793embarr_ed
erred65915673_err_ed
faerie93514683faerie_
faeries104118993faeries
faired105915773fair_ed
fairies103516043fairies
fancied133310603fancied
farced125216533fa_rced
farcie114816473farcie_
farcies125317883farcies
farded114518953fa_rded
fared95842343fa_r_ed
farmed125117653fa_rmed
farriers113610743farriers
farriery14295403farriery
farrowed1545283farrowed
farside1138603farside
farted105121783fa_rted
ferries103521083ferries
firrier103410133firrier
flurried12235283flurried
fried95322913__fried
furred104514433furr_ed
furrier103513663furrier
gallied94115003gallied
garaged1039253garaged
garbed104815663ga_rbed
garbled114512803garbled
gargled104210673gargled
garoted9710133garoted
garret74426563garr_et
garreted1057523garreted
garring93116713garring
garroted1056783garroted
gharries12318213gharries
gloried9169523gloried
gnarred9327013gnarr_ed
gurries83515953gurries
hagride1237553hagride
haired105117173hair_ed
hairier103111053hairier
hardier114721543hardier
hardies114923233hardies
hared95742183ha_r_ed
harked145422553ha_rked
harmed125218833ha_rmed
harped124418403ha_rped
harpies123818323harpies
harriers113712433harriers
harrowed1556263harrowed
hatred104814333hatr_ed
hayride1437323hayride
herries104025073herries
horrid10311563horri_d
hurrier103412943hurrier
hurries103919653hurries
jarring153613193jarring
jerreed1535213jerreed
jerrid14259143jerri_d
jerries143817513jerries
juried144212443_juried
kauries113613193kauries
kerries113317913kerries
knarred12266003knarr_ed
laired75216813lair_ed
larded84319093la_rded
lardier83518343lardier
larked114519473la_rked
larkier113711523larkier
larruped1142863larruped
lazied164610653la_zied
lorries74518353lorries
maced108528693ma__ced
machined1637303machined
mackled164111923mackled
macled116718113ma_cled
maculed123510053maculed
madded113513553ma_dded
maderized2247023maderized
madre85720173madr_e_
madres93718183madr_es
magpie1139093magpie_
magpies12310363magpies
maid75537663ma__i_d
mailed95326753ma_iled
maimed114812663ma_imed
majored1735853majored
malfed12369763ma_lfed
malled94626113ma_lled
malmier113611953malmier
malted94819863ma_lted
maltier93015483maltier
mamboed14417623mamboed
mamie95826003ma_mie_
mamies104626243ma_mies
mammie94313783mammie_
mammies104314763mammies
managed113212603managed
maned86634103ma__ned
mangier104114063mangier
mangled113615263mangled
mankind1437773mankind
manlier92414023manlier
manned94418643ma_nned
mantid93820383manti_d
mantled104113393mantled
manured1039473manured
mapped134015883ma_pped
maraud938943ma_raud
marauded1244333marauded
maravedi1442813maravedi
marble104219103marble_
marbler113511673marbler
marbles114516653marbles
marblier1256343marblier
marcel103714853ma_rcel
marchen143312073marchen
marcher143912973marcher
marches143921173marches
mare64759333ma_r_e_
mares76457633ma_r_es
marge85328333ma_rge_
marges94525713ma_rges
margin94016853margi_n
margins103815193margins
maria75032883ma_ri_a
marina84623413ma_rina
marine84230403ma_rine
mariner93315993mariner
marines93928013marines
marish114319053ma_rish
marker124420393ma_rker
market123226043ma_rket
marketed1537323marketed
marking144020133marking
marliest102415183marliest
marlin84220903marli_n
marline93320953marline
marlines103818713marlines
marling103322763marling
marlins93420473marlins
marlite92917073marlite
marlites103415263marlites
marmite112413993marmite
marmites122212793marmites
marooned1138563marooned
marque172410503marque_
marquee18218583marquee
marques182610863marques
marram10313883marr_am
marrams11310123marrams
marrano939423marrano
marrers93414313marrers
marriage1147253marriage
marriages1247383marriages
marron83717543marr_on
marrons93216973marrons
marrow112812603marr_ow
marrows122911823marrows
marrowy15236083marrowy
marry104821693marr__y
marrying14157233marrying
marse76231153ma_rse_
marses84827113ma_rses
marshes123615373marshes
marshier1337593marshier
marten84518263ma_rten
martial92415413martial
martian93514683martian
martin84122523marti_n
martinet10319643martinet
marting103325013marting
martini93613873martini
martins93322063martins
martlet93419153martlet
martyred1434283martyred
martyries1446563martyries
martyrized2543533martyrized
marvel113712003ma_rvel
marveled1436433marveled
mashed125325043ma_shed
mashie11315933mashie_
mashies12318253mashies
masjid16187323masji_d
masked134316523ma_sked
masoned1039803masoned
massed94421323ma_ssed
massier93615223massier
masted94025803ma_sted
matched153513963matched
mated85537783ma__ted
materiel10311253materiel
matier84321523ma_tier
matres84522233matr_es
matrices12312083matrices
matrix1539853matri_x
matrixes1738063matrixes
matted94521413ma_tted
matured10310043matured
mauled94817823ma_uled
mavie104722563ma_vie_
mavies114923193ma_vies
mawed115824743ma__wed
maxed155821193ma__xed
maybird1543993maybird
mayed115522403ma__yed
mayweed1634163mayweed
mazed175523873ma__zed
mazier175013063ma_zier
mercies113817563mercies
merged104214953m_erged
merited10313853merited
merriest10311483merriest
merrily1238633merrily
metred95315143metr_ed
mired85729223m_ir_ed
mirier83918363m_irier
mirkier13319053mirkier
mirrored1145773mirrored
miscarried1543823miscarried
mitred94414343mitr_ed
monied94319463m_onied
moored93814173moor_ed
moorier93113073moorier
morbid112511463morbi_d
morphed1537133morphed
morrion959003morrion
morris83814733morri_s
morrises10711073morrises
morticed1377163morticed
mortised1178743mortised
mourned1037763mourned
muddied12339213muddied
mummied11327103mummied
muraled10410833muraled
mured85726703m_ur_ed
murid84520583m_uri_d
murkier133110273murkier
murre74821073murr_e_
murres85019043murr_es
murrey114312263murr_ey
murrine9411483murrine
myriad1235913m_yriad
nacred95212493nacr_ed
narked114116743na_rked
narrated9310323narrated
narrowed1235203narrowed
oared65030653oa_r_ed
paired95017523pair_ed
palsied102911303palsied
pandied113913443pandied
panfried14134933panfried
paraded114014263paraded
parched154013693parched
pardie96021443pardie_
pared86946763pa_r_ed
parged104922043pa_rged
paries84742513pa_ries
parked134425143pa_rked
parled94626293pa_rled
parodied1238333parodied
paroled104217633paroled
parrel84515983parr_el
parriers103612903parriers
parring103222063parring
parroted1158843parroted
parsed96323893pa_rsed
parslied1137823parslied
parted94228683pa_rted
partier93520713partier
parties93230863parties
perries93226603perries
pried84426863__pried
purred94218073purr_ed
quarrier1736843quarrier
quarries1749943quarries
queried1738683queried
rallied83514083rallied
rared65738323ra_r_ed
rarefied1245913rarefied
rarified1239053rarified
recarried1244983recarried
redried93714893redried
refried113513873refried
remarries1147673remarries
retried84419153retried
sabred95916533sabr_ed
sacred94917103sacr_ed
safaried1236253safaried
salaried9311033salaried
sallied83316953sallied
sardined10268663sardined
sarkier113413313sarkier
sauries72821623sauries
savvied1433803savvied
scarred104512633scarr_ed
scarrier10298453scarrier
scried95817303_scried
scurried11267053scurried
serries73925353serries
slurried9285943slurried
smarmier1235033smarmier
smarted105012613sma_rted
smartie9310173smartie_
smarties10312873smarties
sorrier72313733sorrier
sortied83314103sortied
sparred104512863sparr_ed
sparrier10329143sparrier
starred85013453starr_ed
starrier8279463starrier
storied8515163storied
tabbied12297793tabbied
tallied83314753tallied
tardier859719993tardier
tardies84225863tardies
tared69340053ta_r_ed
tarre55825633tarr_e_
tarres64723043tarr_es
tarriers83411713tarriers
tarriest83215003tarriest
tarring83318303tarring
tarsier74119253tarsier
tarted74923373ta_rted
tartier74123263tartier
tarweed1137343tarweed
taxied14509373ta_xied
terrier73414963terrier
terries73425633terries
torrid7311853torri_d
tried65026913__tried
undried92314613undried
unharried1344763unharried
unmarred11258403unmarr_ed
unmarrieds1341533unmarrieds
untried82615853untried
updried11226473updried
varier94619353va_rier
varies94330873va_ries
varved134110603va_rved
waddied13358563waddied
waired106015833wair_ed
warbled133212163warbled
warded115021043wa_rded
wared96339873wa_r_ed
warier93722893wa_rier
warked144421213wa_rked
warmed124516893wa_rmed
warned104018913wa_rned
warped124816413wa_rped
warren95012853warr_en
warring113717973warring
warrior1045363warrior
warsled112910443warsled
warted104223233wa_rted
wartier103413913wartier
wearied112911803wearied
wherried15175013wherried
whirried15154103whirried
worrier102311683worrier
worries104117133worries
worrited1235743worrited
wried95518563__wried
yarded114714023ya_rded
yarned105514023ya_rned
yirred10426963yirr_ed

Search took 7 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 Limit1340275376.28021341.9
3Display Results5375370.2032645.3
 (SQL Overall)1786915376.88925938.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.