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

131 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
crankily175562(None) 
crankly16358121crank_ly
cannily1239262c_annily
chancily1845242chancily
chunkily2043082chunkily
crabbily1744342crabbily
crackly18397702crack_ly
craftily1644782craftily
craggily1543702craggily
crankier14339162crankier
cranking154613072cranking
crankish1736512crankish
crankle133610062crank_le
cranky153910632crank__y
crazily2136922cra_zily
creakily1735392creakily
crinkly16387522crink_ly
croakily1744732croakily
frankly17315632frank_ly
lankily1437122_lankily
rankly133910452_rank_ly
swankily1833832swankily
balkily16266693_balkily
blankly1634263blank_ly
brainily1337313brainily
brassily1336623brassily
brawnily1644083brawnily
cagily12411563c_a_gily
campily1638273c_ampily
candidly1545213c_andidly
carnally1339523carnally
carnify1555883carn_ify
cattily123210853c_attily
charily15310283cha_rily
chattily1634603chattily
cheekily2053473cheekily
clammily1743633clammily
clankier14327083clankier
clanking154313063clanking
clankingly2043313clankingly
clanky15469073clank__y
classily1336623classily
cockily1838493c_ockily
cornily12410853corn_ily
cracking174013903cracking
crackle153611253crack_le
cracky175010223crack__y
cramoisy1543703cramoisy
crania82418433cran_i_a
cranial92114683cran_ial
cranially1447893cranially
craning103620303cran_ing
cranium11911103cran_ium
crank114819613crank___
cranked143812843crank_ed
cranker133612793crank_er
crankest1438143crankest
crankiest1538823crankiest
crankled15408153crankled
crankles143510153crankles
crankling16147293crankling
crankous1435973crankous
crankpin16103753crankpin
crankpins17133763crankpins
cranks125015313crank__s
crannied1137893crannied
crannies10313013crannies
cranny114210273cran__ny
crassly1276653cra_ssly
cravenly1644663cravenly
crawly144610763cra__wly
creamily1536363creamily
creepily1574953creepily
crinkle13359413crink_le
crispily1574693crispily
croupily1544743croupily
crunchily1943193crunchily
crusily12199093cr_usily
crustily13328173crustily
dandily12279633_dandily
dankly14419463_dank_ly
draftily1534413draftily
fancily1538253_fancily
flakily1736293fla_kily
franking164310863franking
franklin15104603franklin
franticly1744013franticly
freakily1835003freakily
frenzily2343733frenzily
friskily1834503friskily
funkily1736513_funkily
gawkily1834093_gawkily
grandly1238743gran_dly
grassily1236433grassily
handily143610873_handily
kinkily1335223_kinkily
lankly13439623_lank_ly
leakily1436473lea_kily
mangily1339753_mangily
manlily1238743_manlily
pawkily1934203_pawkily
pranking153813383pranking
prankish1737023prankish
prankishly2242413prankishly
quakily2336693qua_kily
racily11715173_ra_cily
rainily10310433_rainily
rancidly1444433_rancidly
ranking124320883_ranking
rankish14510383_rankish
rankle103414883_rank_le
riskily1436413_riskily
scantily1337583scantily
scraggily1642663scraggily
scrappily1842673scrappily
shakily1736903sha_kily
slangily1235383slangily
slinkily1534853slinkily
snakily1436913sna_kily
snarkily1534583snarkily
sparkily1735023sparkily
spunkily1733773spunkily
stalkily1534823stalkily
tackily1637503_tackily
trashily1437323trashily
trendily1256443trendily
trickily1736233trickily
wackily1936053_wackily
wrathily1744773wrathily
wrinkly17295753wrink_ly
zanily18310183_zan_ily

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 Filter1786911461620.470380193.6
2DLD Change Limit1461621317.36019859.0
3Display Results1311310.0462847.8
 (SQL Overall)1786911317.87622688.0
 
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.