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

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

66 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
paltriness124499(None) 
maltiness112910572malt_iness
paltriest1138602paltri_est
paltrinesses1445512paltrinesses
paperiness1446132paperiness
pastiness112312352past_iness
patroness1137482pa_troness
saltiness93312112salt_iness
sultriness1045562sultriness
airiness8412213_a_iriness
alertness946053_alertness
angriness1036453_angriness
antsiness937843_antsiness
artiness81615403_art_iness
artsiness937653_artsiness
balkiness1556903bal_kiness
balminess1356593bal_miness
battiness11239843ba_ttiness
cattiness112310633ca_ttiness
earthiness1377243earthiness
fattiness12239373fa_ttiness
faultiness1344823fault_iness
filthiness1643713filthiness
glariness1038553_glariness
hairiness1238013ha_iriness
hastiness122410883hast_iness
healthiness1744093healthiness
latrines8515003la_trine_s
matiness102114753ma_t_iness
nastiness92310573nast_iness
nattiness9239333na_ttiness
palatines11313033palatine_s
paleness10312983pal__eness
pallidness1343283pallidness
paltrier1037523paltri_e_r
pantries101817393pantri_e_s
pastness102510503past__ness
pastries101517423pastri_e_s
patchiness1744933patchiness
patines95225763pa_t_ine_s
patness92912283pa_t__ness
pawkiness1835443pa_wkiness
pelerines11311843pelerine_s
peltries10313023peltri_e_s
pettiness1178703p_ettiness
pithiness1437563p_ithiness
portliness1246833portliness
pottiness1179703p_ottiness
prettiness1257393prettiness
psaltries1185743psaltri_e_s
pulpiness1335603pul_piness
saltines82917793salt_ine_s
saltness82610243salt__ness
salutariness1253163salutariness
savoriness1354933savoriness
slatiness92511363slat_iness
talkiness1356913tal_kiness
tarriness9229243ta_rriness
tartiness92112053tart_iness
tastiness92311143tast_iness
tattiness9239413ta_ttiness
tawdriness1482843tawdriness
wariness11313213wa__riness
wateriness1348073wateriness
wealthiness1742853wealthiness
wintriness1345543wintriness

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603665.62325005.0
3Display Results66660.0332000.0
 (SQL Overall)178691666.06229477.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.