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

55 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
skimpiness184286(None) 
skimpiest1734502skimpi_est
skimpinesses2043182skimpinesses
skinniness1443312skinniness
sliminess1137422slim_iness
swampiness1773352swampiness
wimpiness1635292_wimpiness
bumpiness1535283_bumpiness
campiness1537543_campiness
crispiness1444793crispiness
dippiness1435973_dippiness
dumpiness1435653_dumpiness
flimsiness1543453flimsiness
griminess1236693grim_iness
grumpiness1543263grumpiness
hippiness1635463_hippiness
humpiness1635773_humpiness
jumpiness2034293_jumpiness
kinkiness1235763_kinkiness
liminess10510643_lim_iness
limpidness1543083_limpidness
limpness1246703_limp_ness
lippiness1335413_lippiness
lumpiness1336483_lumpiness
nippiness1334713_nippiness
pipiness1238003_pi_piness
riminess10510093_rim_iness
sappiness1337433s_appiness
seaminess11310473seam_iness
seemliness1244153seemliness
shiftiness1644793shiftiness
shininess1237333shi_niness
silkiness1337253s_ilkiness
silliness9510353s_illiness
simpleness1445173s_impleness
sissiness8217963s_issiness
siziness1737423s_i_ziness
skimmings18243263skimmin_gs
skimpier1634293skimpi_e_r
skimping17306243skimpin__g
sleepiness1245133sleepiness
slimness1036523slim__ness
slinkiness1445153slinkiness
sloppiness1443743sloppiness
snappiness1443823snappiness
sniffiness1643753sniffiness
soapiness1138293s_oapiness
soppiness1336543s_oppiness
spiciness1347053spi_ciness
spiffiness1842983spiffiness
spikiness1536313spi_kiness
spininess1137963spi_niness
stickiness1635903stickiness
stinginess1145953stinginess
wispiness1435633_wispiness

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 Filter1786911406030.313570897.8
2DLD Change Limit140603557.18619566.2
3Display Results55550.0301833.3
 (SQL Overall)178691557.52923733.7
 
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.