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 “patternless” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
patternless134228(None) 
bitterness1245553bittern_ess
butterless1244193butter_less
cotterless1244033cotter_less
fatherless1644213father_less
paperless1345833pa_per_less
partnerless1351883partner_less
patterers112410133patter__ers
patterned1265753pattern_e_d
patternings1443183patternings
patterns10439943pattern___s
utterness946223_uttern_ess
waterless1238013wa_ter_less
actionless1244154_actionless
angerless1045024_anger_less
attendees1044054_atte_ndees
attenders1045284_atte_nders
attorneys1252034_attorn_eys
batteners11238184batte_n_ers
batterers113110724batter__ers
batteries11615134batter_ie_s
battiness11239844batt_in_ess
buttonless1242964butt_onless
captionless1552504captionless
cateress102311614ca_ter__ess
catteries11815554catter_ie_s
cattiness112310634catt_in_ess
centerless1245004center_less
dapperness1543154dappern_ess
datedness1187754da_tedn_ess
dateless9259964da_te__less
eagerness1046264ea_gern_ess
easterners1044844eastern_ers
fatteners12236884fatte_n_ers
fattiness12239374fatt_in_ess
featherless1743914feather_less
fernless1136064___fernless
gateless9279954ga_te__less
hammerless1742374hammer_less
jitteriness1843274jitteriness
lateness82614074la_te_n_ess
letterpress13111644letterpress
lusterless1043694luster_less
mannerless1243524manner_less
mateless102711294ma_te__less
mateyness1444474ma_teyn_ess
mattress1036534matt_r__ess
motherless1544094mother_less
natheless1244964nathe__less
nattiness9239334natt_in_ess
otherness1245514_othern_ess
painless10108354pa___inless
paleness10312994pa_le_n_ess
palterers11249544palter__ers
paltriness1244994palt_riness
paneless102611774pa_ne__less
pantdress1243364pantdr__ess
paperiness1446134pa_periness
parentless1244464pa_rentless
parterres1148084parter_re_s
passionless1352884passionless
pasterns104112624pastern___s
pastiness112312364past_in_ess
pastless102411204past___less
pastness102510504past__n_ess
pastorales1247144pastorale_s
pastoralness1453604pastoralness
patchiness1744934patchin_ess
patentees1196554pa_te_ntees
paternalism1556774pa_ternalism
paternalisms1656084pa_ternalisms
paternalist1358594pa_ternalist
paternalists1456164pa_ternalists
pathless13138044pa_t__hless
patiences1367444patie_nce_s
patientest1245724patie_ntest
patness92912284pa_t__n_ess
patroness1137494pa_t_roness
pattened11299394patte_n_e_d
pattens95414924patte_n___s
pattered112714214patter__e_d
patterer103112184patter__e_r
pattern93712054pattern____
patterning1346074pattern_ing
patters94825194patter____s
peerless1037514p__eer_less
petiteness1248494petite_n_ess
pettiness1178704pett_in_ess
porteress1137934porter__ess
portionless1344044portionless
potterers11218664potter__ers
potteries11313604potter_ie_s
pottiness1179704pott_in_ess
powderless1642594powder_less
powerless1444294p_ower_less
properness1445924propern_ess
putterers11238364putter__ers
puttyless1442014putt__yless
ratteners9237274ratte_n_ers
rottenness1043764rotte_nness
sauternes947024sautern_e_s
shutterless1452134shutter_less
slatternliness146884slatternliness
stateless937564state__less
sternness946094__sternness
tasteless935674taste__less
tattiness9239414tatt_in_ess
termless1036234___termless
thornless1243634__thornless
watercress1543384wa_tercress
wateriness1348084wa_teriness
wattless11268724watt___less

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit1488191129.05016444.1
3Display Results1121120.0462434.8
 (SQL Overall)1786911129.51618778.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.