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

217 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
testiness920975(None) 
tastiness92311141tastiness
bustiness111810472bustiness
destines93619662destine_s
dustiness102211032dustiness
feistiness1345072feistiness
fustiness121910242fustiness
gustiness10189892gustiness
hastiness122410882hastiness
heftiness1536312heftiness
jettiness1675692jettiness
lustiness92010452lustiness
meatiness11311182meatiness
messiness11248222messiness
mistiness111911632mistiness
mustiness112211662mustiness
nastiness92310572nastiness
pastiness112312352pastiness
peskiness15216522peskiness
pettiness1178702pettiness
rustiness92111932rustiness
sestines82717242sestine_s
tartiness92112052tartiness
tattiness9239412tattiness
teariness9310632teariness
testiest82715222testi_est
testinesses111210322testinesses
trustiness1036652trustiness
yeastiness1344882yeastiness
antsiness937843antsiness
artiness81615403_artiness
artsiness937653artsiness
ashiness1138963_ashiness
battiness11239843battiness
beadiness12249233beadiness
beastliness1343333beastliness
beefiness1435583beefiness
beeriness1137863beeriness
bittiness11228333bittiness
boskiness15196513boskiness
bossiness11257423bossiness
bushiness14177763bushiness
business102110693bus_iness
cattiness112310633cattiness
cosiness103214283cos_iness
costliness1245993costliness
crustiness1237293crustiness
cushiness14197183cushiness
cystines1339473cystine_s
deftness1236303deft_ness
dentines93418403dentine_s
destine83719953destine__
destined103312453destine_d
destinies10410843destinies
dewiness1238453de_winess
dirtiness1039473dirtiness
ditsiness1048143ditsiness
dottiness1058043dottiness
dressiness1145543dressiness
duskiness14216683duskiness
easiness8313043_easiness
edginess1036053_edginess
eeriness8311873_eeriness
emptiness1335373emptiness
fastness11238763fast_ness
fattiness12239373fattiness
festiveness1748223festiveness
fetidness1345443fe_tidness
fishiness1537343fishiness
fleshiness16104293fleshiness
frostiness1336563frostiness
fussiness12226583fussiness
gassiness10268313gassiness
gastness9278473gast_ness
geekiness1435413geekiness
gemminess1464633gemminess
germiness1257693germiness
goutiness1038763goutiness
gushiness13206853gushiness
gutsiness10226963gutsiness
headiness132510363headiness
heartiness1338033heartiness
heaviness15207063heaviness
huskiness16206583huskiness
intestines10410253intestine_s
jerkiness20175643jerkiness
jestings16368023jestin_gs
justness1535323just_ness
leafiness1236483leafiness
leakiness1337503leakiness
leeriness938323leeriness
legginess1135033legginess
loftiness1236573loftiness
lostness837683lost_ness
maltiness112910573maltiness
massiness112810143massiness
matiness102114753_matiness
mealiness11310063mealiness
meetness1036653meet_ness
merriness1138293merriness
mestinoes1157313mestinoes
mestinos1048163mestin_os
mossiness11258323mossiness
mushiness14248223mushiness
muskiness15237443muskiness
mussiness11238303mussiness
nattiness9239333nattiness
neatness839153neat_ness
neediness10227733neediness
nerdiness10208333nerdiness
nerviness12226873nerviness
newsiness1236033newsiness
niftiness1236363niftiness
nosiness83211393nos_iness
nuttiness9207563nuttiness
pastness102510503past_ness
pectines121914683pectine_s
peppiness1235183peppiness
perkiness15209163perkiness
pertness10310093pert_ness
pestiest103018413pesti_est
pottiness1179703pottiness
prettiness1257393prettiness
pushiness14197283pushiness
raspiness1137303raspiness
readiness102611853readiness
reediness10239613reediness
reshines112615443reshine_s
restiveness1449663restiveness
restless82713163rest_less
restress82511773rest_ress
retines75134673re_tine_s
riskiness1336963riskiness
rootiness979063rootiness
rosiness82613173ros_iness
runtiness92410393runtiness
ruttiness9258793ruttiness
saltiness93312113saltiness
sassiness8249333sassiness
seaminess11310473seaminess
seediness10219173seediness
sentinels947423sentinels
sestinas8249133sestin_as
sestine73017923sestine__
sexiness1537943se_xiness
sissiness8217963sissiness
slatiness92511363slatiness
sootiness999833sootiness
steadiness1146703steadiness
steaminess1236773steaminess
steeliness1046793steeliness
sweatiness1336463sweatiness
tacitness1134873tacitness
tackiness1557693tackiness
talkiness1356913talkiness
tanginess10239283tanginess
tardiness10229913tardiness
tarriness9229243tarriness
tartness82210133tart_ness
tasteless935673tasteless
tastiest83216633tasti_est
tastinesses111110783tastinesses
tautness8217183taut_ness
tawniness1245123tawniness
teatimes1039443teatime_s
tectites1039993tectite_s
teethless1243703teethless
tektites1236613tektite_s
tenseness947113tenseness
tentiest82115613tenti_est
tentless8229843tent_less
tepidness1244343tepidness
terrines82117553terrine_s
terseness948403terseness
testates83615453testate_s
testcross1142543testcross
testees74215913test__ees
testers74124543test__ers
testes65125823test__e_s
testicles1146773testicles
testier74015643testi_e_r
testifiers13124503testifiers
testifies12139263testifies
testing86021053testin__g
testis64916713testi___s
testons7313563teston__s
testudines1143093testudine_s
tetchiness1543583tetchiness
textiles1536833textile_s
textless15245793text_less
thirstiness1442693thirstiness
tidiness938793t_idiness
tininess8310633t_ininess
tinniness936093tinniness
tipsiness1135703tipsiness
titaness836723t_itaness
tontines82114733tontine_s
trashiness1346443trashiness
trendiness1146223trendiness
triteness9310363triteness
tubbiness1334423tubbiness
tweediness1443173tweediness
vastness11257293vast_ness
vestiges1238243vestige_s
vestings12359143vestin_gs
vestless11258843vest_less
washiness1537043washiness
waspiness1435793waspiness
weariness1238843weariness
weediness13247043weediness
weepiness14215963weepiness
westings12429803westin_gs
wetness10277723we_t_ness
wispiness1435633wispiness
wittiness12197223wittiness
zestiest173011103zesti_est
zestless17247433zest_less

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.796224486.2
2DLD Change Limit1486412176.78321913.8
3Display Results2172170.1062047.2
 (SQL Overall)1786912177.68523251.9
 
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.