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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
painterlinesses179201(None) 
painterliness1572432painterline_s_s
gingerlinesses1652683_gingerlinesses
mannerlinesses1652403ma_nnerlinesses
masterlinesses1673523ma_sterlinesses
princelinesses1892713prince_linesses
saintlinesses1344363saint__linesses
daintinesses1346244daint___inesses
fatherlinesses2052614fa_therlinesses
jitterinesses2083314_jitter_inesses
maidenlinesses1751974mai_denlinesses
miserlinesses1554664_mi_serlinesses
painfulnesses18115134pain_ful_nesses
painlessnesses1546744painle_ssnesses
paltrinesses1445514pa_lt_r_inesses
paperinesses1646044pa__per_inesses
pointednesses1654954pointe__dnesses
waterinesses1567194wa__ter_inesses
wintrinesses1555774_wint_r_inesses
airinesses102613615_ai___r_inesses
angrinesses1247285_a_n_gr_inesses
antsinesses1148755_a_nt__sinesses
austerenesses1354155_auster_enesses
bitternesses1444535_bitter__nesses
brotherlinesses2071245brotherlinesses
centerednesses1753815_centerednesses
dailinesses1249495dai____linesses
dastardlinesses1761835da_stardlinesses
earlinesses11311035ea____rlinesses
earthlinesses1643905ea_rt_hlinesses
elderlinesses1453255__elderlinesses
faintishnesses2053305faint_ishnesses
faintnesses1447145faint____nesses
fierinesses1439235_fi__er_inesses
flintinesses1546325flint___inesses
gainfulnesses17124605gain_ful_nesses
genteelnesses1453525_genteel_nesses
gingerliness1452795_gingerline_s_s
gristlinesses1443985grist__linesses
hairinesses14198945hai___r_inesses
inertnesses1198715__in_er_tnesses
innernesses1146735__inner__nesses
intensenesses1356045__intensenesses
intentnesses1277125__inte_ntnesses
interlinears12144585__interline_ars
interliners11138695__interline__rs
interlines101116455__interlin___es
intrepidnesses1751885__intrepidnesses
invernesses1447025__inver__nesses
jauntinesses1944685jaunt___inesses
jointednesses2174015jointe__dnesses
kindlinesses1744245_kin__dlinesses
kinglinesses1743855_kin__glinesses
leisurelinesses1581045leisurelinesses
literalnesses1355235_li_teralnesses
literarinesses1483355_li_terarinesses
livelinesses15145625_li_ve_linesses
lonelinesses12146345_lon_e_linesses
lubberlinesses1851745_lubberlinesses
manlinesses13910195ma_n___linesses
mannerliness1452565ma_nnerline_s_s
masterliness1463835ma_sterline_s_s
motherlinesses1962355_motherlinesses
nerdinesses1249045___n_erdinesses
nervinesses1437305___n_ervinesses
orderlinesses1453385__orderlinesses
ornerinesses1246555_orn_er_inesses
palatablenesses1973925palatablenesses
palatialnesses1653335palatial_nesses
pantdresses1443755pa_ntdr___esses
pastinesses13911715pa_st___inesses
pastoralnesses1653125pa_storalnesses
patchinesses1944365pa__t_chinesses
patronesses1346475pa__t_r_onesses
paunchinesses2042335paun__chinesses
pepperinesses1653255p_epper_inesses
perkinesses1748915p____erkinesses
piteousnesses1557165p_i_teousnesses
pithinesses1637505p_i_t__hinesses
plaintivenesses2054295plaint_ivenesses
plenteousnesses1783975plenteousnesses
pointlessnesses1655445pointlessnesses
portlinesses1446975p_ort__linesses
pricklinesses2143615pri__cklinesses
priestlinesses1652705pri_estlinesses
princeliness1653015prince_line_s_s
raininesses11310475rain____inesses
saintliness1144155saint__line_s_s
salutarinesses1462775salutar_inesses
silverinesses1643685_silver_inesses
sincerenesses1554725_sincer_enesses
slipperinesses1851855slipper_inesses
statelinesses1344235_state_linesses
steelinesses1246725___steelinesses
timelinesses1445455_ti_me_linesses
wifelinesses1844815_wi_fe_linesses

Search took 9 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 Filter178691658740.0931921408.6
2DLD Change Limit65874967.5168764.5
3Display Results96960.453211.9
 (SQL Overall)178691968.06222164.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.