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

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

91 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
sketchiness205217(None) 
sketchiest1943162sketchi_est
sketchinesses2251882sketchinesses
tetchiness1543582_tetchiness
bitchiness1743793_bitchiness
itchiness1444753__itchiness
patchiness1744933_patchiness
preachiness1844283preachiness
scratchiness1962383scratchiness
sketchers1834513sketch__ers
sketches1746823sketch__e_s
sketchier1853413sketchi_e_r
sketching1935083sketchin__g
slouchiness1642653slouchiness
starchiness1643943starchiness
achiness1339704___achiness
breathiness1644324breathiness
butchness1643454_butch_ness
crunchiness1843284crunchiness
earthiness1377244eart_hiness
etchings14396294__etchin_gs
filthiness1643714filt_hiness
fleshiness16104294fle_shiness
fletchings19282864fletchin_gs
frothiness1645724frot_hiness
grouchiness1742764grouchiness
jettiness1675694_jet_tiness
katchinas1843924_katchin_as
kerchiefs2141764_kerchi_efs
ketamines15177034_ketamine_s
ketches164012194_ketch__e_s
kitchenets1952324_kitchenets
kvetchiest2241954kvetchi_est
paunchiness1842344paunchiness
pettiness1178704_pet_tiness
pithiness1437564_pit_hiness
prettiness1257394pret_tiness
raunchiness1642884raunchiness
saltiness93312114salt__iness
sauciness1138044s_auc_iness
seaminess11310474s_e_aminess
seediness10219174s_e_ediness
seemliness1244154s_eemliness
setlines8312744s_et_line_s
sexiness1537944s_e__xiness
sketchbooks216974sketchbooks
sketched1835394sketch__e_d
sketcher1735434sketch__e_r
sketchily2142334sketchi__ly
sketchpads2261184sketch_pads
skewness1533764ske___wness
skimpiness1842864sk_impiness
skinniness1443314sk_inniness
slatiness92511364slat__iness
sleaziness19104704sle_aziness
sleepiness1245134sle_epiness
slushiness1344644s_lushiness
smutchiest1743264smutchi_est
smuttiness1244404smut_tiness
snatchiest1545154snatchi_est
sneakiness1454874sne_akiness
snottiness1055594snot_tiness
sootiness999834soot__iness
spaciness1337084s_pac_iness
speechless1742324speech_less
speediness1345224spe_ediness
spiciness1347054s_pic_iness
splashiness1642544splashiness
spottiness1285764spot_tiness
squashiness2342434squashiness
squishiness2342984squishiness
staginess1038754s__taginess
stateliness1144234stateliness
steadiness1146704ste_adiness
stealthiness1562494stealthiness
steaminess1236774ste_aminess
steeliness1046794ste_eliness
stenchiest1545084stenchi_est
stickiness1635904s_tickiness
stockiness1645244s_tockiness
stoniness938344s__toniness
stretchiest1644194stretchi_est
suchness1335764s__uch_ness
sultriness1045564sult_riness
swarthiness1743384swarthiness
sweatiness1336464swe_atiness
tetchiest1445794_tetchi_est
tetchinesses1753554_tetchinesses
touchiness1544614_touchiness
worthiness1645914wort_hiness
wretchedness2152154wretchedness

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 Filter1786911488190.420425454.8
2DLD Change Limit148819919.25316083.3
3Display Results91910.0461978.3
 (SQL Overall)178691919.71918385.7
 
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.