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

110 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
crankiness163617(None) 
cakiness1449552c_a_kiness
canniness1138642c_anniness
chanciness1745122chanciness
craftiness1545752craftiness
cragginess1444142cragginess
crankiest1538822cranki_est
crankinesses1846142crankinesses
craziness2037382cra_ziness
creakiness1645962creakiness
frankness1655222frank_ness
lankiness1338052_lankiness
randiness102511442_randiness
ranginess101610212_ranginess
rankness12267942_rank_ness
swankiness1744252swankiness
balkiness1556903_balkiness
bandiness122310243_bandiness
blankness1544673blank_ness
braininess1246123braininess
brassiness1235483brassiness
brattiness1255843brattiness
brawniness1544033brawniness
brininess1138203brin_iness
caginess11310303c_a_giness
campiness1537543c_ampiness
candidness1444773c_andidness
canines93724033c_an_ine_s
canoness1039393c_an_oness
cattiness112310633c_attiness
chariness14310063cha_riness
chattiness1565123chattiness
cheekiness1944043cheekiness
clamminess1643613clamminess
clankiest1536673clanki_est
classiness12196313classiness
cleanliness1343263cleanliness
cockiness17248783c_ockiness
corkiness152810443c_orkiness
corniness112611183corn_iness
crackings18346843crackin_gs
cracknels1743433crack_nels
crankcases1842763crankcases
crankest1438143crank__est
crankier14339163cranki_e_r
cranking154613073crankin__g
crankish1736513cranki__sh
crankles143510153crank_le_s
crankpins17133763crankpin__s
crannies10313013cranni_e_s
crassness1136213cra_ssness
cravenness1543883cravenness
creaminess1446203creaminess
creepiness1444883creepiness
crispiness1444793crispiness
crumminess1643693crumminess
crunchiness1843283crunchiness
crustiness1237293crustiness
cyanines132710543cyan_ine_s
dankness13256693_dank_ness
draftiness1444863draftiness
fanciness1437673_fanciness
flakiness1636473fla_kiness
franticness1643603franticness
freakiness1745183freakiness
friskiness1744453friskiness
funkiness16226873_funkiness
gawkiness1734753_gawkiness
graininess1145793graininess
grandness1138303gran_dness
grapiness1238253gra_piness
handiness132110933_handiness
inkiness1238693__inkiness
kinkiness1235763_kinkiness
lankness12237043_lank_ness
larkiness1338113_larkiness
leakiness1337503lea_kiness
manginess122010413_manginess
manliness111310123_manliness
pawkiness1835443_pawkiness
prankishness2153053prankishness
punkiness15226983_punkiness
quakiness2236073qua_kiness
raciness102413453_ra_ciness
raininess949273_raininess
rancidness1344223_rancidness
rankings13389173_rankin_gs
rankless12268233_rank_less
raspiness1137303_raspiness
riskiness1336963_riskiness
rockiness15237833_rockiness
runniness9247103_runniness
runtiness92410393_runtiness
sandiness102111713_sandiness
scantiness1236883scantiness
scrappiness1752293scrappiness
scrawniness1652153scrawniness
shakiness1637083sha_kiness
slanginess1146273slanginess
slinkiness1445153slinkiness
snakiness1367473sna_kiness
spunkiness1644173spunkiness
tackiness1557693_tackiness
talkiness1356913_talkiness
tanginess10239283_tanginess
trashiness1346443trashiness
trendiness1146223trendiness
trickiness1666353trickiness
wackiness1836523_wackiness
zaniness1738663_zan_iness

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 Limit1406031106.32622226.2
3Display Results1101100.0502200.0
 (SQL Overall)1786911106.78226347.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.