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

115 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
sportiness127823(None) 
spottiness1285761spottiness
porkiness15249192_porkiness
portliness1246832_portliness
pottiness1179702_pottiness
shortness1236732short_ness
snootiness1085832snootiness
snottiness1055592snottiness
sootiness999832s_ootiness
sorriness939582s_orriness
sponginess1344592sponginess
spookiness1644432spookiness
sportiest111711022sporti_est
sportinesses1447872sportinesses
sportiveness1766982sportiveness
storminess1245212storminess
apartness1146053apart_ness
artiness81615403__artiness
corkiness152810443_corkiness
corniness112611183_corniness
dirtiness1039473_dirtiness
dorkiness14248053_dorkiness
dottiness1058043_dottiness
forkiness16268703_forkiness
frostiness1336563frostiness
goriness9310753_gor_iness
goutiness1038763_goutiness
heartiness1338033heartiness
horniness12309143_horniness
horsiness12259473_horsiness
knottiness1483593knottiness
loftiness1236573_loftiness
pastiness112312353_pastiness
perkiness15209163_perkiness
pertness10310093_pert_ness
pettiness1178703_pettiness
pokiness14219863_po_kiness
porteress1137933_porteress
portioners1257413_portioners
portionless1344023_portionless
portless10310643_port_less
portress1038323_port_ress
poutines102415103_poutine_s
prosiness11311683_prosiness
pursiness1138453_pursiness
rootiness979063_rootiness
saltiness93312113s_altiness
savoriness1354933savor_iness
scantiness1236883scantiness
scariness11310183scar_iness
scurviness1543283scurviness
serotines9312073serotine_s
shiftiness1644793shiftiness
shoddiness1543563shoddiness
shorteners1345083shorteners
shorties11414583shorti_e_s
showiness1576073sho_winess
slatiness92511363s_latiness
sloppiness1443743sloppiness
smarminess1444303smarminess
smartness1136143smart_ness
smokiness1535543smo_kiness
smoothness1543043smoothness
smuttiness1244403smuttiness
snowiness1296243sno_winess
soapiness1138293s_oapiness
softness1136433s_oft_ness
sogginess1136183s_ogginess
soppiness1336543s_oppiness
sordidness1244633s_ordidness
sordines92414073s_ordine_s
soreness8914793s_or_eness
sorties74126403s_orti_e_s
spaciness1337083sp_aciness
spareness1139863spar_eness
sparseness1245493sparseness
sparteines12105173sparteine_s
spartinas1135793spartin_as
speediness1345223speediness
spermines13310543spermine_s
spiciness1347053sp_iciness
spiffiness1842983spiffiness
spikiness1536313sp_ikiness
spininess1137963sp_ininess
spiritless1243743spiritless
sporters103714063sport__ers
sportfulness1754783sportfulness
sportier102010053sporti_e_r
sporting112415463sportin__g
sportingly1645543sportingly
sportive1348333sportive__
sportively1845023sportively
spotless1037043spo_t_less
spottiest11177683spotti_est
spottinesses1445683spottinesses
spoutings12245153spoutin_gs
spoutless1134243spout_less
spryness1334003sp_r_yness
spunkiness1644173spunkiness
stockiness1645243stockiness
stodginess1243893stodginess
stoniness938343sto_niness
stoutness945863stout_ness
sturdiness1144843sturdiness
sultriness1045563sultriness
surliness939943s_urliness
swarthiness1743383swarthiness
swartness1236113swart_ness
sweatiness1336463sweatiness
tartiness92112053_tartiness
thorniness13264343thorniness
uppitiness1442753uppitiness
wordiness13138633_wordiness
worminess14127613_worminess
worthiness1645913_worthiness

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 Filter1786911406030.406440125.6
2DLD Change Limit1406031156.43621846.3
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.88825942.4
 
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.