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

224 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
lankiness133805(None) 
lankness12237041lank_ness
larkiness1338111larkiness
balkiness1556902balkiness
bandiness122310242bandiness
blankness1544672blank_ness
cakiness1449552ca_kiness
canniness1138642canniness
crankiness1636172crankiness
dankness13256692dank_ness
fanciness1437672fanciness
flakiness1636472fla_kiness
funkiness16226872funkiness
gawkiness1734752gawkiness
handiness132110932handiness
inkiness1238692_inkiness
kinkiness1235762kinkiness
laciness102112552la_ciness
lankiest122912492lanki_est
lankinesses1539012lankinesses
laziness17239982la_ziness
leakiness1337502leakiness
luckiness1596572luckiness
manginess122010412manginess
manliness111310122manliness
pawkiness1835442pawkiness
punkiness15226982punkiness
randiness102511442randiness
ranginess101610212ranginess
rankness12267942rank_ness
sandiness102111712sandiness
slanginess1146272slanginess
slinkiness1445152slinkiness
snakiness1367472snakiness
swankiness1744252swankiness
tackiness1557692tackiness
talkiness1356912talkiness
tanginess10239282tanginess
wackiness1836522wackiness
zaniness1738662zan_iness
achiness1339703_achiness
airiness8412213_airiness
alanines8314803alan_ine_s
alikeness1336333alikeness
alkines114415733_alkine_s
angriness1036453_angriness
antsiness937843_antsiness
artiness81615403_artiness
ashiness1138963_ashiness
bagginess1355953bagginess
balminess1356593balminess
bankings15489403bankin_gs
battiness11239843battiness
bawdiness15235543bawdiness
blackness1735663black_ness
blandness1235973blan_dness
boniness102211803bon_iness
bonniness1136733bonniness
boskiness15196513boskiness
bulkiness1555933bulkiness
caginess11310303ca_giness
campiness1537543campiness
candidness1444773candidness
canines93724033can_ine_s
canoness1039393can_oness
cattiness112310633cattiness
chanciness1745123chanciness
clamminess1643613clamminess
clankiest1536663clanki_est
classiness12196313classiness
cleanliness1343263cleanliness
cockiness17248783cockiness
corkiness152810443corkiness
daffiness1634843daffiness
dailiness1038673dailiness
daintiness1145963daintiness
darkness13247343dark_ness
dinginess1137823dinginess
dorkiness14248053dorkiness
duskiness14216683duskiness
earliness939693earliness
easiness8313043ea_siness
fanciless1444603fanciless
fanzines2036913fanzine_s
fattiness12239373fattiness
flabbiness1742523flabbiness
flashiness16105283flashiness
flintiness1345893flintiness
flukiness1635453flukiness
forkiness16268703forkiness
frankness1655223frank_ness
funniness12256533funniness
gabbiness1434403gabbiness
gaminess112911063ga_miness
gassiness10268313gassiness
gaudiness1136253gaudiness
gauziness1934613gauziness
geekiness1435413geekiness
glariness1038553gla_riness
glassiness11245993glassiness
glaziness1935753gla_ziness
hairiness1238013hairiness
hamminess1635713hamminess
hankies143617763hanki_e_s
happiness1635993happiness
hardiness132310353hardiness
hastiness122410883hastiness
haziness20248513ha_ziness
hokiness152510183_hokiness
huskiness16206583huskiness
ickiness1436753_ickiness
jauntiness1743973jauntiness
jazziness2432843jazziness
jerkiness20175643jerkiness
jokiness19227393_jokiness
kookiness1235563kookiness
lakiest113517263la_ki_est
lakings124713513la_kin_gs
lameness102612673la_meness
lanciers10308543lanci_ers
landings103110073landin_gs
landless94011173lan_dless
landlines1039763landline_s
languidness1342323languidness
lankest112714113lank__est
lankier113711633lanki_e_r
lanknesses1437503lank_nesses
lanners73618333lan__ners
lanolines939983lanoline_s
largeness1038273largeness
larkiest123713313larki_est
larkinesses1538993larkinesses
lateness82614073la_teness
latrines8515003latrine_s
lauwines1145713lauwine_s
lawines103313563la_wine_s
laxness1436043la__xness
leafiness1236483leafiness
leanness837373lean__ness
leeriness938323leeriness
legginess1135033legginess
likeness12229863l_ikeness
liminess10510643l_iminess
lippiness1335413lippiness
loaminess1137493loaminess
loftiness1236573loftiness
loginess9310163l_oginess
loneliness1046083loneliness
loneness8512093lon_eness
longness938553lon_gness
looniness9137573looniness
loopiness11136543loopiness
lousiness9219033lousiness
lowliness1236403lowliness
lumpiness1336483lumpiness
lustiness92010453lustiness
maltiness112910573maltiness
massiness112810143massiness
matiness102114753ma_tiness
maziness19239543ma_ziness
milkiness1536523milkiness
murkiness15206293murkiness
muskiness15237443muskiness
nankins1159053nankin__s
nappiness1335233nappiness
nastiness92310573nastiness
nattiness9239333nattiness
packness1636933pack_ness
pastiness112312353pastiness
perkiness15209163perkiness
peskiness15216523peskiness
pickiness1737623pickiness
pinkness1436513pink_ness
planeness1138153plan_eness
plankings16326113plankin_gs
pluckiness1883823pluckiness
pokiness14219863_pokiness
porkiness15249193porkiness
puniness101610273pun_iness
quakiness2236073quakiness
raciness102413453ra_ciness
raininess949273raininess
rancidness1344223rancidness
rankings13389173rankin_gs
rankless12268233rank_less
raspiness1137303raspiness
riskiness1336963riskiness
rockiness15237833rockiness
runniness9247103runniness
runtiness92410393runtiness
saltiness93312113saltiness
saneness82313723san_eness
sappiness1337433sappiness
sassiness8249333sassiness
sauciness1138043sauciness
savviness1534713savviness
scantiness1236883scantiness
shakiness1637083shakiness
silkiness1337253silkiness
slackness1535433slack_ness
slatiness92511363sla_tiness
smokiness1535543smokiness
spikiness1536313spikiness
spunkiness1644173spunkiness
sulkiness1347353sulkiness
sunniness9247943sunniness
tankinis12245913tankin_is
tankless12267823tank_less
tardiness10229913tardiness
tarriness9229243tarriness
tartiness92112053tartiness
tastiness92311143tastiness
tattiness9239413tattiness
tawniness1245123tawniness
tininess8310633tin_iness
tinniness936093tinniness
wanness102610683wan__ness
wariness11313213wa_riness
washiness1537043washiness
waspiness1435793waspiness
waviness1437723wa_viness
waxiness1836723wa_xiness
windiness1337373windiness
yuckiness1874923yuckiness

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.1701051123.5
2DLD Change Limit1486412247.64319448.0
3Display Results2242240.1062113.2
 (SQL Overall)1786912247.91922564.8
 
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.