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

350 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
marriers10331247(None) 
barriers104311881barriers
carriers103614201carriers
farriers113610741farriers
harriers113712431harriers
marrers93414311marr_ers
marrieds11288071marrieds
marrier93817521marrier_
marries93825281marrie_s
parriers103612901parriers
tarriers83411711tarriers
arrivers11137002_arrivers
barrier94017732barrier_
carrier93619582carrier_
carries94328012carrie_s
curriers103410752curriers
farrier103514892farrier_
farriery14295402farriery
furriers11369492furriers
harrier104417752harrier_
harries103525492harrie_s
hurriers11358892hurriers
marblers12319232marblers
marchers153710812marchers
mariners103113862mariners
markers133516102ma_rkers
marlier92614772marlier_
marrer83716672marr_er_
married104715302marrie_d
merrier92612302merrier_
murries94118672murrie_s
parrier93717652parrier_
parries93925842parrie_s
partiers103514242partiers
quarriers1845182quarriers
tarrier74323172tarrier_
tarries73324262tarrie_s
tarsiers8298532tarsiers
terriers84210822terriers
variers103712662va_riers
warriors1135362warriors
worriers11257812worriers
aerier64823153_aerier_
aeries64737783_aerie_s
airers64922313_air_ers
airier64619363_airier_
ambries111614553ambrie_s
amercers1256133amercers
arbiters1038853_arbiters
archers124414573_archers
arguers8489033_arguers
ariels65119373_a_riels
armers85520273_a_rmers
armies85123693_armie_s
armigers1135703_armigers
arrayers11125853_arrayers
arrears738843_arrears
arris56824683_arri__s
arrises71617583_arrises
arriver10117793_arriver_
arrives101311513_arrives
artier63419733_artier_
barbers114317503ba_rbers
barbies114519593barbie_s
barkers134318513ba_rkers
barkier133814483barkier_
barmier114313043barmier_
barnier93213673barnier_
barraters1138043barraters
barrels94514363barr_els
barrens94414323barr_ens
barres84427543barr_e_s
barrets94917103barr_ets
barrios9310773barri_os
barristers1244723barristers
barters94223033ba_rters
berries94423553berrie_s
brasiers103710513brasiers
braziers19397193braziers
briers85319733__briers
buriers94017193_buriers
burrers93814493burr_ers
burrier93613553burrier_
cahiers123510673ca_hiers
carders104820353ca_rders
careers95218783ca_reers
carers85133963ca_r_ers
caries85147623ca_rie_s
carnies94123963carnie_s
carolers103314173carolers
carpers114521253ca_rpers
carrels95117303carr_els
carried103717153carrie_d
carrions10312453carrions
carters95327253ca_rters
carvers124817533ca_rvers
cashiers13318883cashiers
catbriers1344143catbriers
charrier1378683charrier_
corries94026793corrie_s
couriers103213173couriers
criers83918583__criers
currier93316703currier_
curriery13326163curriery
curries93723163currie_s
dairies84217733dairie_s
dalliers93610613dalliers
darbies104216983darbie_s
darers75921873da_r_ers
darkies124015753darkie_s
darners83815773da_rners
darters84017603da_rters
decriers11299733decriers
derriere936043derriere
derrieres1044813derrieres
derries83124623derrie_s
driers74516733__driers
durries83817353durrie_s
earlier72612743earlier_
earners74016453ea_rners
earrings9299633earrings
faeries104118993faerie_s
fairies103516043fairie_s
fanciers13358083fanciers
farcers124713443fa_rcers
farcies125317883farcie_s
farers95924053fa_r_ers
farmers124315263fa_rmers
farrieries1344343farrieries
ferries103521083ferrie_s
firrier103410133firrier_
friers94718933__friers
furrier103513663furrier_
furriery14395683furriery
furriners12316323furriners
gambiers13337073gambiers
garblers113810283garblers
garglers10418263garglers
garners83815983ga_rners
garrets84413623garr_ets
garroters1055813garroters
garters84218233ga_rters
gharries12318203gharrie_s
graziers18387123graziers
gurries83515953gurrie_s
hagriders1443553hagriders
hairier103111053hairier_
hardier114721543hardier_
hardies114923233hardie_s
harmers124116593ha_rmers
harpers124916203ha_rpers
harpies123818313harpie_s
harried113815533harrie_d
harrowers1555683harrowers
hauliers1176713hauliers
herries104025073herrie_s
hurrier103412943hurrier_
hurries103919653hurrie_s
jerries143817513jerrie_s
kauries113613193kaurie_s
kerries113317913kerrie_s
lanciers10308543lanciers
larders83516943la_rders
lardier83518343lardier_
larkers113014513la_rkers
larkier113711523larkier_
larrupers1142523larrupers
lorries74518343lorrie_s
macers105321273ma__cers
madders113513213ma_dders
madres93718183madr_e_s
maftirs1236043mafti_rs
magpies12310363magpie_s
mailers94420333ma_ilers
maimers113813043ma_imers
mairs76228303ma__i_rs
makers123921733ma__kers
malmier113611953malmier_
maltier93015483maltier_
mamies104626243ma_mie_s
mammers104615693ma_mmers
mammies104314763mammie_s
mamzers20409163ma_mzers
managers112911003managers
mangers103521263ma_ngers
mangier104114063mangier_
manglers113311903manglers
manlier92414023manlier_
manners93417833ma_nners
manurers1037593manurers
mappers133313783ma_ppers
marauders1244263marauders
marbler113511673marbler_
marbles114516653marble_s
marblier1256343marblier_
marcels113212373ma_rcels
marcher143912973marcher_
marches143921173marche_s
mares76457633ma_r_e_s
marges94525713ma_rge_s
margins103815193margi_ns
marinas93519383ma_rinas
mariner93315993mariner_
marines93928013ma_rines
marker124420393ma_rker_
marketers1545983marketers
markets133314033ma_rkets
markhors1745393markhors
markings153410243markings
marliest102415183marliest
marlines103818713marlines
marlings113713493marlings
marlins93420473marli_ns
marlites103415263marlites
marmites122212793marmites
marquees19206243marquees
marques182610863marque_s
marquess19204953marquess
marrams11310123marr_ams
marranos1038423marranos
marred95421043marr_e_d
marriage1147253marriage
marriages1247383marriages
marring103319553marri_ng
marrons93216973marr_ons
marrows122911823marr_ows
marses84827113ma_rse_s
marshes123615373marshe_s
marshier1337593marshier_
martens93714953ma_rtens
martians103111613martians
martinets1138883martinets
martinis103311613martinis
martins93322063marti_ns
martlets103310483martlets
martyries1446563martyrie_s
martyrs1234893ma_rtyrs
marvels123810093ma_rvels
masers84623453ma__sers
mashers124621053ma_shers
mashies12318253mashie_s
maskers133913843ma_skers
masquers19195703masquers
massier93615223massier_
masters94628923ma_sters
matchers153012433matchers
materiels1147833materiels
maters85032393ma__ters
matier84321523ma_tier_
matres84522233matr_e_s
matrices12312083matrices
matrixes1738063matrixes
matters94421753ma_tters
maturers1037373maturers
maulers94213303ma_ulers
maunders11348343maunders
mavies114923193ma_vie_s
mazers173917093ma__zers
mazier175013063ma_zier_
mercers114412773m_ercers
mercies113817563mercie_s
mergers103813423m_ergers
merriest10311473merriest
merriness1138293merriness
metiers93312843m_etiers
milliers102611903milliers
mirier83918363m_irier_
mirkier13319053mirkier_
mirrors938623mirr_ors
moorier93113073moorier_
morrions1077673morrions
morris83814733morri__s
morrises10711073morrises
mortisers1186163mortisers
mourners1036913mourners
murders103311363m_urders
murkier133110273murkier_
murres85019043murr_e_s
murreys12367323murr_eys
murthers1336543murthers
narraters946703narraters
paniers94717333pa_niers
panniers10488853panniers
paraders113113113paraders
pardners11269193pardners
parers85530743pa_r_ers
paries84742513pa_rie_s
parkers133816873pa_rkers
parrels94713493parr_els
parried103615723parrie_d
parroters1156763parroters
parsers94118153pa_rsers
partier93520713partier_
parties93230863partie_s
partners102711133partners
partyers13277763partyers
perries93226603perrie_s
priers84521193__priers
quarrier1736843quarrier_
quarries1749943quarrie_s
quartiers1845183quartiers
queriers1736963queriers
ralliers84010833ralliers
rapiers95012873ra_piers
rarefiers1244023rarefiers
remarries1147673remarrie_s
salliers83613343salliers
saltiers83411953saltiers
sarkier113413313sarkier_
sauciers1076733sauciers
sauries72821623saurie_s
scarrier10298453scarrier_
serries73925353serrie_s
smarmier1235033smarmier_
smarties10312873smartie_s
sorrier72313733sorrier_
sparrier10329143sparrier_
spurriers11245063spurriers
starrier8279463starrier_
talliers83711373talliers
tardier859719993tardier_
tardies84225863tardie_s
tarres64723043tarr_e_s
tarried83914133tarrie_d
tarriest83215003tarriest
tarriness9229243tarriness
tarsier74119253tarsier_
tartier74123263tartier_
terrier73414963terrier_
terries73425633terrie_s
triers64321523__triers
unmarrieds1341533unmarrieds
varier94619353va_rier_
varies94330873va_rie_s
verniers11227843verniers
warblers13319103warblers
warders113416813wa_rders
warier93722893wa_rier_
warmers124514293wa_rmers
warners103315563wa_rners
warpers123413583wa_rpers
warreners1236193warreners
warrens103810893warr_ens
warrior1045363warrior_
warslers11328073warslers
wartier103413913wartier_
worrier102311683worrier_
worries104117133worrie_s
yarders113211593ya_rders
yarners104312203ya_rners

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.1561145455.1
2DLD Change Limit1461623506.78321548.3
3Display Results3503500.1232845.5
 (SQL Overall)1786913507.06225303.2
 
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.