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

73 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
itchiness144475(None) 
bitchiness1743791bitchiness
achiness1339702_achiness
iciness938862i_c_iness
ickiness1436752i_ckiness
itchiest1336522itchi_est
itchinesses1644602itchinesses
itchings14386192itchin_gs
patchiness1744932patchiness
pithiness1437562pit_hiness
tetchiness1543582tetchiness
archines133815253archine_s
archness1337513arch_ness
ashiness1138963_ashiness
bitchiest1636083bitchi_est
bitchinesses1943513bitchinesses
bittiness11228333bit_tiness
bushiness14177753bushiness
butchness1643453butch_ness
chicness1535593__chicness
chines115029173__chine_s
chinless1337493__chinless
cockiness17248783cockiness
cushiness14197183cushiness
ditsiness1048133dit_siness
ditziness1945883dit_ziness
etchings14396293etchin_gs
filthiness1643713filthiness
fishiness1537343fishiness
gushiness13206853gushiness
iffiness1435023i_ffiness
incliners1146333incliners
inclines10313133incline_s
inkiness1238693i_nkiness
itches114916213itch__e_s
itchier12247673itchi_e_r
itching134011683itchin__g
kitchenets1952323kitchenets
laciness102112553lac_iness
litheness1247363lit_heness
luckiness1596573luckiness
machines15312883machine_s
muchness1534073much_ness
mushiness14248213mushiness
nitchies1339073nitchi_e_s
pickiness1737623pickiness
pitchiest1646703pitchi_est
pushiness14197283pushiness
raciness102413453rac_iness
richness1337433rich_ness
ritziness1835823rit_ziness
rockiness15237833rockiness
sketchiness2052173sketchiness
staginess1038753staginess
starchiness1643943starchiness
stickiness1635903stickiness
stockiness1645243stockiness
stoniness938343stoniness
suchness1335763such_ness
tackiness1557693tackiness
thinness11277153_t_hinness
tidiness938793_tidiness
tightness1386603tightness
tininess8310633_tininess
tinniness936093tinniness
tipsiness1135703tipsiness
touchiness1544613touchiness
wackiness1836523wackiness
washiness1537043washiness
witchiest1736313witchi_est
witchings18325303witchin_gs
wittiness12197223wit_tiness
yuckiness1874923yuckiness

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641736.56022658.7
3Display Results73730.0501460.0
 (SQL Overall)178691736.76626410.1
 
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.