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

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

198 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
piquantnesses245203(None) 
piquantness2251522piquantne_s_s
distantnesses1453833distantnesses
pliantnesses1444453p_liantnesses
quaintnesses2143823__quaintnesses
squatnesses2045213_squa_tnesses
bluntnesses1345394_blu_ntnesses
frequentnesses2661424frequentnesses
gauntnesses1245174_gau_ntnesses
giantesses1143514gi__ant_esses
inanenesses1149524_i_nanenesses
inaptnesses1385634_i_naptnesses
insanenesses1246874_insanenesses
instantnesses1354064instantnesses
intactnesses1444574_intactnesses
intentnesses1277124_intentnesses
liquidnesses2243084liqu_idnesses
militantnesses1661874militantnesses
pastnesses12910514p___astnesses
patnesses111611794p___a_tnesses
peartnesses1338744p__eartnesses
pinknesses1636584pi___nknesses
piousnesses1348984piou__snesses
planenesses1349034p__lanenesses
pleasantnesses1661564pleasantnesses
presentnesses1554424presentnesses
profanenesses1853484profanenesses
puninesses121110754p__u_ninesses
quakinesses2436324__quakinesses
quietnesses2045604__quietnesses
scantnesses1376534__scantnesses
silentnesses1275444si_lentnesses
squarenesses2144974_squarenesses
unquietnesses2253054unquietnesses
vacantnesses1742974_vacantnesses
valiantnesses1652724valiantnesses
abruptnesses1652615abru_ptnesses
adequatenesses2462635adequatenesses
adultnesses1244835_adu_ltnesses
ancientnesses1553285ancientnesses
apartnesses1346825__apartnesses
apparentnesses18121775apparentnesses
aptnesses11168995____aptnesses
augustnesses1352685augu_stnesses
biasnesses1236965bi__a_snesses
bindingnesses1753275bindingnesses
blandnesses1446625__blandnesses
blanknesses1744935__blanknesses
boundnesses1446625_bou_ndnesses
canonesses1238415___canonesses
casualnesses1443785casua_lnesses
cleannesses13135825_clean_nesses
cliquishnesses2852115cliquishnesses
compactnesses2153005compactnesses
countesses1248845_cou_nt_esses
currentnesses1552995currentnesses
curtnesses1238375__cu_rtnesses
daftnesses1436385___daftnesses
danknesses1536255___danknesses
dilutenesses1346115dilu_tenesses
directnesses1595285di_rectnesses
dismalnesses1553985disma_lnesses
distantness1254335distantne_s_s
distinctnesses1752565distinctnesses
dunnesses1037705__du_n_nesses
enchantresses18101325enchantresses
equablenesses2465535_equablenesses
exactnesses2044345__exactnesses
faintnesses1447145__faintnesses
fastnesses1389085___fastnesses
fatnesses121710465___fa_tnesses
finenesses13310715fi___nenesses
firstnesses1445735fi__rstnesses
fitnesses12219375fi____tnesses
fittingnesses1773405fittingnesses
flatnesses1337765__fla_tnesses
franknesses1845605__franknesses
funninesses14106875__funninesses
gastnesses11129145___gastnesses
genuinenesses1475305genuinenesses
grandnesses1348115__grandnesses
greatnesses1247795_grea_tnesses
hiddennesses1752655hidden_nesses
humanenesses1744255_humanenesses
humannesses1643865_human_nesses
huntresses1345285__hu_ntresses
ignorantnesses1562215ignorantnesses
ineptnesses1396385_i_neptnesses
inertnesses1198725_i_nertnesses
inexactnesses2252915inexactnesses
inhumannesses1852175inhuman_nesses
innatenesses1247185_innatenesses
inventresses1553025_inventresses
inwardnesses1654675_inwardnesses
iratenesses11411445_i_ratenesses
ironnesses1047835_i_ron_nesses
jauntinesses1944685_jau_ntinesses
jejunenesses1852625jeju_nenesses
justnesses1736495__ju_stnesses
kindnesses1537215ki___ndnesses
lanknesses1437505___lanknesses
leannesses10108345__lean_nesses
licitnesses1346415li__citnesses
lightnesses1546145li__ghtnesses
liltingnesses1453575liltingnesses
livingnesses1643665li_vingnesses
meannesses12128165__mean_nesses
minutenesses1476175minu_tenesses
mundanenesses1653545mundanenesses
neatnesses10310015__nea_tnesses
opaquenesses2352965opaqu__enesses
packnesses1856625p___acknesses
palenesses12312665p___alenesses
pantdresses1443755p___antdresses
pastinesses13911715p___astinesses
perfectnesses2053355perfectnesses
permanentnesses1961305permanentnesses
pertnesses12310315p___ertnesses
phoninesses1636455p__honinesses
pickinesses1996835pi__ckinesses
pigginesses1555615pi__gginesses
piggishnesses2043285piggishnesses
pinkishnesses2243985pinkishnesses
pipinesses1448605pi___pinesses
piquances2244055piqua__n__ces
piquancies2343235piqua__n_cies
piteousnesses1557175piteousnesses
pithinesses1637505pi__thinesses
pitiablenesses1855065pitiablenesses
pitifulnesses1855575pitifulnesses
pixinesses1937375pi___xinesses
plainnesses1356205p__lainnesses
pliantness1263645p_liantne_s_s
pluckinesses2043995p_luckinesses
plumbnesses1753075p_lu_mbnesses
plumpnesses1753265p_lu_mpnesses
plushinesses1744725p_lushinesses
plushnesses1645585p_lu_shnesses
privatenesses1855345privatenesses
promptnesses1843635p_romptnesses
pronenesses1379265p__ronenesses
proudnesses1447505prou__dnesses
pudginesses1545055p__udginesses
puffinesses1934515p__uffinesses
pugginesses1545255p__ugginesses
pulpinesses1536005p__ulpinesses
punkinesses17127225p__unkinesses
purenesses12810745p__u_renesses
pursinesses1338745p__ursinesses
pushinesses1697335p__ushinesses
quaintness1943205__quaintne_s_s
queasinesses2144175__queasinesses
queernesses2044575__queernesses
quicknesses2643755__quicknesses
ranknesses1438095___ranknesses
raptnesses1248525___raptnesses
recentnesses1465375_recentnesses
rightnesses1546235ri__ghtnesses
robustnesses1443785robu_stnesses
rotundnesses1343825rotu_ndnesses
roundnesses1247045_rou_ndnesses
runninesses11137695__runninesses
runtinesses111210965__ru_ntinesses
saltnesses10310165___saltnesses
sanenesses10412695___sanenesses
scantinesses1437315__scantinesses
sinuousnesses1247315sinuousnesses
smartnesses1337145__smartnesses
soundnesses1247525_sou_ndnesses
spininesses1358455spi___ninesses
squalidnesses2352105_squalidnesses
squashinesses2442385_squashinesses
squatness1844945_squa_tne_s_s
stoutnesses1146975stou__tnesses
straitnesses1246215_straitnesses
suavenesses1448425__suavenesses
sunninesses11148385__sunninesses
swartnesses1436715__swartnesses
tartnesses101110715___tartnesses
tautnesses10118285___tautnesses
tightnesses1565585ti__ghtnesses
tininesses10311165ti___ninesses
tinninesses1136865ti__nninesses
titanesses1037255ti_ta__nesses
unaptnesses1395525__unaptnesses
uniquenesses2154715uniqu__enesses
unjustnesses1963115unju_stnesses
usualnesses1144695_usua_lnesses
vastnesses13128205___vastnesses
villainesses1543515villa_inesses
vitalnesses1456275vi_ta_lnesses
wannesses1239235___wan_nesses
whatnesses1635735__wha_tnesses
willingnesses1753175willingnesses
witnesses12219925wi____tnesses
womannesses1644395_woman_nesses
youngnesses1544285_you_ngnesses
zaninesses19310385___zaninesses

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901989.04613795.0
3Display Results1981980.1261571.4
 (SQL Overall)1786911989.31219189.3
 
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.