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

108 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
marshals133778(None) 
marshal1238971marshal_
marshall1345481marshall
marshalls1444831marshalls
darshans1286542darshans
marsala939582mars_ala
marsalas1038252mars_alas
marshalcy1951772marshalcy
marshaled1544642marshaled
marshes123615372marsh_es
narwhals1443612narwhals
tarsals72512602tars_als
archils12510533_archils
argals75517713_ar_gals
arhats9312973_ar_hats
arsenals847733_arsenals
arshins10312573_arshins
barchans1588683barchans
bashaws15347713ba_shaws
borstals1037463borstals
caracals12310743caracals
carpals113414623car_pals
cashaws15398573ca_shaws
casuals91410523ca_suals
causals91411183caus_als
darshan1167063darsha_n
dorsals84110843dors_als
earshots1146623earshots
farfals13268503far_fals
hardhats1546833hardhats
harshens1437603harshens
harshly1636273harsh_ly
hartals10313023har_tals
kashas133311903ka_sha_s
madrigals13856233madrigals
malthas1237913maltha_s
mammals10389273ma_mmals
manuals9311213ma_nuals
maracas11313773maraca_s
maras75443293mar__a_s
marascas1247383marasca_s
marcels113212373mar_cels
marchers153710813marchers
marches143921173march_es
margays1337493mar_gays
marginals1246003marginals
marinas93519383marina_s
marishes13512553marish_es
marital92314183marital_
markas124717003mar_ka_s
markhors1745393markhors
markkas12356083markka_s
marls75535163mar___ls
marrams11310123mar_rams
marses84827113mars__es
marsh105320853marsh___
marshalcies1851563marshalcies
marshaling1645083marshaling
marshalled1642543marshalled
marshalship21102773marshalship
marshier1337593marshier
marshiest1438103marshiest
marshland1543353marshland
marshlands1642763marshlands
marshy14558333marsh__y
marsupials1451653marsupials
martial92415413martial_
martians103111613martians
marvels123810093mar_vels
masala8311813ma_s_ala
masalas9312053ma_s_alas
masas75630413ma_s_a_s
mashers124621053ma_shers
mashes115030003ma_sh_es
mashies12318253ma_shies
massas85116463ma_ssa_s
matsahs1236563mats_ahs
maximals19325223maximals
mescals112911553m_escals
mishaps1438713m_ishaps
miskals13369763m_iskals
missals93914423m_issals
morals85324633mor__als
morsels94112653mors_els
mortals93914003mor_tals
mughals1355763m_ughals
murals84016763mur__als
murrhas12286173murrha_s
narwals1036983nar_wals
narwhal1344333narwhal_
narwhale1443223narwhale
narwhales1543163narwhales
nasals63312463na_s_als
padshahs17113153padshahs
parashahs1744743parashahs
parrals94414573par_rals
partials101911953partials
pascals11610013pa_scals
paschals1566473paschals
pashas115117063pa_sha_s
rascals959663ra_scals
sarsars73512143sars_ars
sashays1336333sa_shays
tarsal63315273tars_al_
tarsias74013373tarsia_s
vassals1057953va_ssals
warsaws1335763wars_aws
warships1647553warships

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.436409841.7
2DLD Change Limit1461621086.79621507.1
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.27824552.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.