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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

177 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
wittiness1219722(None) 
bittiness11228331bittiness
battiness11239842battiness
cattiness112310632cattiness
dirtiness1039472dirtiness
ditsiness1048152ditsiness
ditziness1945882ditziness
dottiness1058042dottiness
fattiness12239372fattiness
grittiness1145182grittiness
jettiness1675692jettiness
mistiness111911632mistiness
nattiness9239332nattiness
niftiness1236362niftiness
nuttiness9207562nuttiness
pettiness1178702pettiness
pithiness1437562pithiness
pottiness1179702pottiness
ritziness1835832ritziness
ruttiness9258792ruttiness
tattiness9239412tattiness
wiliness1139112wi_liness
wimpiness1635292wimpiness
windiness1337372windiness
wintriness1345542wintriness
wiriness1138952wi_riness
wispiness1435632wispiness
witness103010012wi_t_ness
wittiest112711522witti_est
wittinesses14127482wittinesses
wittings12328732wittin_gs
airiness8412223ai_riness
antsiness937853antsiness
artiness81615413_artiness
artsiness937673artsiness
bitchiness1743793bitchiness
bitterness1245553bitterness
bittiest103012043bitti_est
bittinesses13148263bittinesses
bittings11339293bittin_gs
brattiness1255843brattiness
bustiness111810483bustiness
chattiness1565123chattiness
citrines102513133citrine_s
daintiness1145963daintiness
dinginess1137823dinginess
dippiness1435973dippiness
ditties83116983ditti_e_s
dizziness1834183dizziness
dustiness102211033dustiness
emptiness1335373emptiness
feistiness1345073feistiness
fieriness1238623fieriness
filminess1435983filminess
filthiness1643713filthiness
fishiness1537343fishiness
fitness10299393fi_t_ness
fittingness1553173fittingness
fittings12318203fittin_gs
flintiness1345893flintiness
fustiness121910243fustiness
giddiness1234693giddiness
goutiness1038773goutiness
guiltiness1144203guiltiness
gustiness10189903gustiness
gutsiness10226973gutsiness
hastiness122410883hastiness
heftiness1536313heftiness
hilliness1248923hilliness
hippiness1635463hippiness
iciness938863_i_ciness
ickiness1436753_ickiness
iffiness1435023_iffiness
inkiness1238693_inkiness
intines7921113_intine_s
itchiness1444753_itchiness
jitteriness1843273jitteriness
kinkiness1235763kinkiness
kitties113213623kitti_e_s
knottiness1483593knottiness
licitness1145373licitness
liminess10510643li_miness
lippiness1335413lippiness
liteness82213213li_teness
litheness1247363litheness
littleness1045023littleness
loftiness1236573loftiness
lustiness92010453lustiness
maltiness112910573maltiness
matiness102114753_matiness
meatiness11311183meatiness
miffiness1734523miffiness
mightiness1645093mightiness
milkiness1536523milkiness
miriness10310463mi_riness
mustiness112211663mustiness
nastiness92310573nastiness
nippiness1334713nippiness
nittiest82712603nitti_est
oiliness8311563oi_liness
pastiness112312353pastiness
pickiness1737623pickiness
pigginess1375453pigginess
pipiness1238003pi_piness
pitiless10127333pi_tiless
pittings11349123pittin_gs
pixiness1736093pi_xiness
prettiness1257393prettiness
riminess10510103ri_miness
riskiness1336973riskiness
rootiness979063rootiness
runtiness92410393runtiness
rustiness92111943rustiness
saltiness93312113saltiness
shiftiness1644793shiftiness
silkiness1337253silkiness
silliness9510363silliness
sissiness8217973sissiness
sittings9339733sittin_gs
siziness1737423si_ziness
slatiness92511363slatiness
smuttiness1244403smuttiness
snottiness1055593snottiness
sootiness999833sootiness
spottiness1285763spottiness
sweatiness1336463sweatiness
swiftness1543653swift_ness
tartiness92112053tartiness
tastiness92311143tastiness
testiness9209753testiness
tidiness938793ti_diness
tininess8310633ti_niness
tinniness936093tinniness
tipsiness1135713tipsiness
titaness836723ti_taness
titties73617363titti_e_s
vitalness1245413vitalness
vitrines112610913vitrine_s
wackiness1836523wackiness
wariness11313213w_ariness
washiness1537043washiness
waspiness1435793waspiness
wateriness1348073wateriness
wattless11268723watt_less
waviness1437723w_aviness
waxiness1836723w_axiness
weariness1238843weariness
weediness13247043weediness
weepiness14215963weepiness
weightiness1843263weightiness
wetness10277723w_et_ness
wettings12348403wettin_gs
whatness1435093what_ness
whininess1535123whininess
whiteness1546483whiteness
wideness12259473wi_deness
wifeliness1644483wifeliness
wiftiest14279173wifti_est
wildness1236203wi_ldness
wiseness112010753wi_seness
withies133913543withi_e_s
withiest142411243withi_est
withins133511693within__s
witless103310983wi_t_less
witlings12328443witlin_gs
witneys13274723wi_t_neys
witticism1693823witticism
witticisms1793473witticisms
wittier103910823witti_e_r
witting113417063wittin__g
wittingly1644803wittingly
woodiness13147873woodiness
wooliness12147693wooliness
wooziness21125213wooziness
wordiness13138633wordiness
worminess14127613worminess
worthiness1645913worthiness

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 Filter1786911486410.470380193.6
2DLD Change Limit1486411777.17020731.0
3Display Results1771770.0802212.5
 (SQL Overall)1786911777.72023146.5
 
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.