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

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

192 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
painterliness157243(None) 
painterlinesses1792012painterlinesses
gingerliness1452793_gingerliness
interliners11138693__interliners
interlines101116453__interline_s
mannerliness1452563ma_nnerliness
masterliness1463833ma_sterliness
princeliness1653033prince_liness
saintliness1144163saint__liness
centerlines1346994_centerline_s
daintiness1145964daint___iness
fatherliness1853324fa_therliness
interline91218014__interline__
interlinear11145694__interlinear
interlinears12144584__interlinears
interlined111211264__interline_d
interliner101311154__interline_r
interlinks14137504__interlin_ks
jitteriness1843274_jitter_iness
maidenliness1552084mai_denliness
miserliness1344914_mi_serliness
painfulness1645094pain_ful_ness
painlessness1445454painle_ssness
paltriness1244994pa_lt_r_iness
paperiness1446134pa__per_iness
partnerless1351884partnerl__ess
pointedness1445094pointe__dness
printeries12410674printer_i_e_s
wateriness1348084wa__ter_iness
waterlines1348954wa__terline_s
wintriness1345544_wint_r_iness
afterlifes1643185_a_fterlife_s
afterlives1643555_a_fterlive_s
airiness8412225_ai___r_iness
airliners945985_ai___rliners
airlines8312795_ai___rline_s
angerless1045025_a_ngerl__ess
angriness1036465_a_n_gr_iness
anserines9411295_a_nser_ine_s
anticlines1249365_a_nticline_s
antsiness937855_a_nt__siness
austereness1154295_auster_eness
bitterness1245555_bitter__ness
brotherliness1881865brotherliness
centeredness1554255_centeredness
centerless1245005_centerl__ess
centerline1247045_centerline__
chitterlings1851415chitterlin_gs
countermines1649155countermine_s
dailiness1038675dai____liness
dastardliness1561375da_stardliness
datelines1088855da__te_line_s
dinnerless1152715_dinnerl__ess
earliness939705ea____rliness
earthliness14144145ea_rt_hliness
easterlies1046715ea_sterli_e_s
elderliness1242855__elderliness
faintishness1863065faint_ishness
faintness1235835faint____ness
fieriness1238635_fi__er_iness
fingerlings1642895_fingerlin_gs
flintiness1345905flint___iness
gainfulness1544625gain_ful_ness
gantlines1039335ga_nt__line_s
genteelness1252805_genteel_ness
gingerlinesses1652685_gingerlinesses
gristliness1264025grist__liness
hairiness1238015hai___r_iness
hairlines1237135hai___rline_s
hinterlands1553005_hinterlan_ds
inertness947975__in_er_tness
innerness946915__inner__ness
intenseness1156575__intenseness
intentness1047365__inte_ntness
interfiles1349995__interfile_s
interlaces12412055__interlace_s
interlayers1445335__interlayers
interlends1148605__interlen_ds
interlining1249135__interlining
interlinings1355065__interlinings
interlink131310665__interlin__k
interlinked1644845__interlinked
interlopers1346195__interlopers
interlopes1249275__interlope_s
interludes1147395__interlude_s
intermixes1948395__intermixe_s
internees93014845__inter__nees
internes82721235__inter__ne_s
interties9320345__interti_e_s
intertwines1446645__intertwine_s
interveners14107305__interveners
intervenes131012655__intervene_s
interviews1645265__intervi_ews
intestines10410265__intestine_s
intrepidness1552525__intrepidness
inverness1247135__inver__ness
jauntiness1743975jaunt___iness
jointedness1954065jointe__dness
kindliness1544045_kin__dliness
kingliness1543955_kin__gliness
leisureliness1361105leisureliness
linerless936335_lin_erl__ess
literalness1145495_li_teralness
literariness1253995_li_terariness
liveliness1345635_li_ve_liness
loneliness1046085_lon_e_liness
lubberliness1671655_lubberliness
mainliners1244015main___liners
mainlines1138525main___line_s
maintainers1352835maint__ainers
manliness111310125ma_n___liness
mannerless1243525ma_nnerl__ess
mannerlinesses1652405ma_nnerlinesses
masterlinesses1673525ma_sterlinesses
motherliness1753085_motherliness
nerdiness10208335___n_erdiness
nerviness12226875___n_erviness
orderliness1243065__orderliness
orneriness1045445_orn_er_iness
painless10108355pain___l__ess
paintbrushes197895paintbrushe_s
painterly1443315painterl____y
painters103013035painter_____s
paintiest11310565paint___i_est
paintings12327105paint___in_gs
palatableness1754655palatableness
palatialness1453245palatial_ness
paneless102611775pa_n_e_l__ess
panelings12107465pa_n_e_lin_gs
panellings1344555pa_n_ellin_gs
pantalones1246725pa_nt_alone_s
pantdress1243365pa_ntdr___ess
pantries101817395pa_nt_r_i_e_s
papaverines1852055papaver_ine_s
paperless1345835pa__perl__ess
papeteries1446565papeter_i_e_s
passerines1246165pa_sser_ine_s
pastiness112312365pa_st___iness
pastoralness1453605pa_storalness
patchiness1744935pa__t_chiness
patroness1137495pa__t_r_oness
patternings1443185pa_tternin_gs
patternless1342285pa_tter_nless
paunchiness1842345paun__chiness
pepperiness1443435p_epper_iness
perkiness15209175p____erkiness
pincerlike1843005p_incerlike__
pineries102419085p_in_er_i_e_s
pipelines13178355p_i_pe_line_s
piperines131610695p_i_per_ine_s
piteousness1347265p_i_teousness
pithiness1437565p_i_t__hiness
plaintiveness1854095plaint_iveness
plenteousness1554555plenteousness
pointelles1245015pointe_l_le_s
pointless1135715point__l__ess
pointlessness1554615pointlessness
portliness1246835p_ort__liness
preinterviews2161325preintervi_ews
prickliness1943925pri__ckliness
priestliness1452925pri_estliness
princeliest1554335prince_li_est
princelinesses1892725prince_linesses
princelings1642585prince_lin_gs
printless1137525print__l__ess
raininess949295rain____iness
reinterviews1851615reintervi_ews
saintliest1046025saint__li_est
saintlinesses1344365saint__linesses
salutariness1253165salutar_iness
sanderlings1343435sa_nderlin_gs
silveriness1443855_silver_iness
sincereness1345005_sincer_eness
slatternliness146885slatternliness
slipperiness1651945slipper_iness
stateliness1144235_state_liness
steeliness1046795___steeliness
taintless935745taint__l__ess
tangerines1147545ta_nger_ine_s
timberlines1583285_timberline_s
timeliness1245305_ti_me_liness
underlines111512115__underline_s
unmannerliness166985unmannerliness
vitellines1394735_vi_telline_s
waistlines1343895waist__line_s
waterless1238015wa__terl__ess
waterline1249655wa__terline__
wifeliness1644485_wi_fe_liness
winteriest1348815_winter_i_est
winterizes2247145_winter_ize_s
wintertides1544475_wintertide_s
wintertimes1643915_wintertime_s

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 Filter1786911247900.406440125.6
2DLD Change Limit1247901929.15613629.3
3Display Results1921920.1231561.0
 (SQL Overall)1786911929.68518450.3
 
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.