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

209 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
marrieds1128807(None) 
married104715301married_
marriers103312471marriers
marries93825281marrie_s
barriers104311882barriers
carried103717152carried_
carriers103614202carriers
carries94328012carrie_s
farriers113610742farriers
harried113815532harried_
harriers113712432harriers
harries103525492harrie_s
marred95421042marr_ed_
marrers93414312marr_ers
marrier93817522marrie_r
murries94118672murrie_s
parried103615722parried_
parriers103612902parriers
parries93925842parrie_s
tarried83914132tarried_
tarriers83411712tarriers
tarries73324262tarrie_s
unmarrieds1341532unmarrieds
aeried74221863_aeried_
aeries64737783_aerie_s
ambries111614553ambrie_s
ariels65119373_a_riels
armies85123693_armie_s
aroids75118223_aroi_ds
arris56824683_arri__s
arrises71617583_arrises
arrived11127353_arrived_
arrivers11137003_arrivers
arrives101311513_arrives
barbies114519593barbie_s
barred95725793barr_ed_
barrels94514363barr_els
barrens94414323barr_ens
barres84427543barr_e_s
barrets94917103barr_ets
barrier94017733barrie_r
barrios9310773barri_os
berried103714043berried_
berries94423553berrie_s
carbides133111693carbides
caried94528693ca_ried_
caries85147623ca_rie_s
carnies94123963carnie_s
carrels95117303carr_els
carrier93619583carrie_r
carrions10312453carrions
cirripeds1442053cirripeds
corries94026793corrie_s
curried103313653curried_
curriers103410753curriers
curries93723163currie_s
dairies84217733dairie_s
darbies104216983darbie_s
darkies124015753darkie_s
derries83124623derrie_s
durries83817353durrie_s
earrings9299633earrings
faeries104118993faerie_s
fairies103516043fairie_s
farcies125317883farcie_s
farrier103514893farrie_r
farriery14295403farriery
farsides1237993farsides
ferried113411523ferried_
ferries103521083ferrie_s
furriers11369493furriers
garred85217403garr_ed_
garrets84413623garr_ets
gharries12318203gharrie_s
gurries83515953gurrie_s
hagrides1337623hagrides
hardies114923233hardie_s
harpies123818313harpie_s
harrier104417753harrie_r
hatreds11307813hatr_eds
hayrides1536883hayrides
herried113514453herried_
herries104025073herrie_s
hurried113511043hurried_
hurriers11358893hurriers
hurries103919653hurrie_s
jarred144613253jarr_ed_
jerreeds1653273jerreeds
jerrids15277743jerri_ds
jerries143817513jerrie_s
kauries113613193kaurie_s
kerries113317913kerrie_s
lorries74518343lorrie_s
madres93718183madr_e_s
magpies12310363magpie_s
maids86327143ma__i_ds
malteds10377603ma_lteds
mamies104626243ma_mie_s
mammies104314763mammie_s
mantids103113623manti_ds
marauds1037553ma_rauds
maravedi1442813maravedi
maravedis1542963maravedis
marbled123212113marbled_
marblers12319233marblers
marbles114516653marble_s
marcels113212373ma_rcels
marched153813403marched_
marchers153710813marchers
marches143921173marche_s
mares76457633ma_r_e_s
marges94525713ma_rge_s
margined1237743margined_
margins103815193margi_ns
marinas93519383ma_rinas
mariners103113863mariners
marines93928013ma_rines
marked133921623ma_rked_
markers133516103ma_rkers
markets133314033ma_rkets
markings153410243markings
marled95523163ma_rled_
marlier92614773marlie_r
marliest102415183marliest
marlines103818713marlines
marlings113713493marlings
marlins93420473marli_ns
marlites103415263marlites
marmites122212793marmites
marquees19206243marquees
marques182610863marque_s
marquess19204953marquess
marrams11310123marr_ams
marranos1038423marranos
marrer83716673marr_e_r
marriage1147253marriage
marriages1247383marriages
marring103319553marri_ng
marrons93216973marr_ons
marrowed1445973marrowed_
marrows122911823marr_ows
marses84827113ma_rse_s
marshes123615373marshe_s
marted94425213ma_rted_
martens93714953ma_rtens
martians103111613martians
martinets1138883martinets
martinis103311613martinis
martins93322063marti_ns
martlets103310483martlets
martyries1446563martyrie_s
marvels123810093ma_rvels
mashies12318253mashie_s
masjids17175403masji_ds
materiels1147833materiels
matres84522233matr_e_s
matrices12312083matrices
matrixes1738063matrixes
mavies114923193ma_vie_s
maybirds1643323maybirds
mayweeds1742993mayweeds
mercies113817563mercie_s
merrier92612303merrie_r
merriest10311473merriest
merriness1138293merriness
morrions1077673morrions
morris83814733morri__s
morrises10711073morrises
murids93212193m_uri_ds
murres85019043murr_e_s
murreys12367323murr_eys
myriads1334353m_yriads
paries84742513pa_rie_s
parred95024073parr_ed_
parrels94713493parr_els
parrier93717653parrie_r
partied103516553partied_
partiers103514243partiers
parties93230863partie_s
perries93226603perrie_s
quarried1836093quarried_
quarriers1845183quarriers
quarries1749943quarrie_s
remarried1244933remarried_
remarries1147673remarrie_s
sauries72821623saurie_s
serried82513963serried_
serries73925353serrie_s
smarties10312873smartie_s
tardies84225863tardie_s
tarred74720283tarr_ed_
tarres64723043tarr_e_s
tarrier74323173tarrie_r
tarriest83215003tarriest
tarriness9229243tarriness
tarsiers8298533tarsiers
tarweeds1244273tarweeds
terriers84210823terriers
terries73425633terrie_s
unmarried1244583unmarried_
varied104817863va_ried_
variers103712663va_riers
varies94330873va_rie_s
warred104019843warr_ed_
warrens103810893warr_ens
warriors1135363warriors
worried11308693worried_
worriers11257813worriers
worries104117133worrie_s

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.423422437.4
2DLD Change Limit1461622097.03020791.2
3Display Results2092090.0802612.5
 (SQL Overall)1786912097.53323721.1
 
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.