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

208 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
crankiest153882(None) 
clankiest1536661clankiest
crankest1438141crank_est
brakiest143912242bra_kiest
branniest11199382branniest
cakiest133215662c_a_kiest
canniest10313362c_anniest
chalkiest1837082chalkiest
chanciest1638372chanciest
chinkiest1867022chinkiest
chunkiest1835262chunkiest
clunkiest1535162clunkiest
crabbiest1535622crabbiest
crackliest1844882crackliest
craftiest1436912craftiest
craggiest13116522craggiest
crampiest15268612crampiest
crankier14339162crankie_r
crankiness1636172crankiness
crankish1736512cranki_sh
crankles143510152crankles_
crannies10313012crannies_
crappiest15267262crappiest
crawliest14187402crawliest
craziest19319922cra_ziest
creakiest15238592creakiest
crinkliest16104522crinkliest
croakiest15167172croakiest
frankest1536962frank_est
lankiest122912492_lankiest
orangiest1038462orangiest
randiest93418772_randiest
rangiest93115982_rangiest
rankest112713812_rank_est
skankiest12145702skankiest
swankiest16136202swankiest
balkiest144112453_balkiest
barkiest144115153_barkiest
barniest104815053barn_iest
beakiest143313463bea_kiest
blankest14439063blank_est
braggiest13116783braggiest
brainiest11209723brainiest
branchiest1746713branchiest
brandies11714563brandies_
brashiest14359853brashiest
brassiest11369713brassiest
brattiest1148103brattiest
brawliest14177193brawliest
brawniest14197103brawniest
brickiest1737433brickiest
briniest102812323brin_iest
bronziest2035813bronziest
cagiest102916433c_a_giest
campiest142212133c_ampiest
candidest1346533c_andidest
candies104125613c_andies_
canoeist10310693c_anoeist
carnies94123963carn_ies_
cattiest103016333c_attiest
chaffiest2045413chaffiest
chanties132615803chanties_
chariest13315503cha_riest
charriest1438253charriest
chattiest1448203chattiest
cheekiest1835703cheekiest
chokiest1738723c_hokiest
clammiest1535733clammiest
clankier14327083clankie_r
classiest11309543classiest
clayiest1337913cla_yiest
cleanliest1244353cleanliest
clingiest1257133clingiest
coaliest10316223coa_liest
cockiest163013293c_ockiest
corkiest143114793c_orkiest
corniest102117303corn_iest
crackles164111273crackles_
crakes124921813cra_k_es_
cranches153114543cranches_
cranes84330753cran__es_
crankcase1742343crankcase
cranked143812843crank_e_d
cranker133612793crank_e_r
crankily1755623cranki_ly
cranking154613073cranki_ng
crankle133610063crankle__
crankled15408153crankle_d
crankous1435973crankous_
crankpins17133763crankpins_
cranks125015313crank__s_
crannied1137893crannie_d
crappies142911153crappies_
crassest103411523cra_ssest
crazies183413853cra_zies_
creamiest13248933creamiest
creasiest11229943creasiest
creepiest1337063creepiest
crepiest12310383cr_epiest
crimpiest15237183crimpiest
crinkles14269163crinkles_
crispiest13197423crispiest
cronies9622503cron_ies_
crookest1436683crook_est
croupiest1337063croupiest
cruddiest1334453cruddiest
crumbiest1536253crumbiest
crummiest1545563crummiest
crunchiest1764793crunchiest
crustiest112410053crustiest
dandiest103415033_dandiest
dankest122611673_dank_est
dinkiest133812873_dinkiest
draffiest1644363draffiest
draftiest1335943draftiest
draggiest12126413draggiest
drawliest13166243drawliest
drunkest1334423drunk_est
fanciest133612713_fanciest
flakiest153210543fla_kiest
frankness1655223frankness
freakiest16206693freakiest
fringiest1347603fringiest
friskiest1636233friskiest
funkiest152810973_funkiest
gawkiest16327313_gawkiest
grabbiest1435323grabbiest
grainiest10188993grainiest
grandest10311573gran_dest
grannies9312613grannies_
grapiest112211923gra_piest
grassiest10309513grassiest
grungiest1135803grungiest
gunkiest132610573_gunkiest
handiest123417773_handiest
hankies143617763_hankies_
hinkiest153311753_hinkiest
hunkiest153812333_hunkiest
inkiest113415043__inkiest
junkiest192610173_junkiest
kinkiest113110503_kinkiest
lakiest113517263_la_kiest
lankest112714113_lank_est
larkiest123713313_larkiest
leakiest123212793lea_kiest
mangiest112815903_mangiest
manliest102314943_manliest
oakiest112913923_oa_kiest
pawkiest17277883_pawkiest
peakiest143512993pea_kiest
plunkiest1535503plunkiest
prankish1737023pranki_sh
prickiest1748183prickiest
punkiest149312663_punkiest
quackiest2435183quackiest
quakiest2138583qua_kiest
raciest92820013_ra_ciest
rainiest81214923_rainiest
rammiest12299933_rammiest
randies84225663_randies_
rankish14510383_ranki_sh
rankles113114543_rankles_
rankless12268233_rankless
rankness12267943_rankness
raspiest10311273_raspiest
rattiest83516113_rattiest
reekiest122711313_reekiest
riskiest12310133_riskiest
rockiest142912223_rockiest
rookiest122912173_rookiest
runniest82911203_runniest
runtiest83014513_runtiest
sandiest93218683_sandiest
sarkiest123615063_sarkiest
scantiest112611003scantiest
scraggiest1444363scraggiest
scrappiest1644153scrappiest
scrawliest1553813scrawliest
scrawniest1543483scrawniest
shakiest151910933sha_kiest
skunkiest12135093skunkiest
slangiest10129073slangiest
slinkiest13188073slinkiest
snakiest122110543sna_kiest
snarkiest13207633snarkiest
sparkiest15188093sparkiest
spunkiest15166563spunkiest
stalkiest1347903stalkiest
stinkiest13198463stinkiest
swankest15105933swank_est
tackiest143112433_tackiest
talkiest123611223_talkiest
tangiest92915223_tangiest
trampiest13227893trampiest
trannies8415013trannies_
transient9713213transient
trashiest123110633trashiest
trendiest1038423trendiest
trickiest1549023trickiest
twangiest1355223twangiest
twankies1535893twankies_
wackiest172610273_wackiest
waniest103819113_wan_iest
whackiest2144983whackiest
wonkiest1538943_wonkiest
wrathiest1536973wrathiest
wrinkliest1743833wrinkliest
zaniest163214773_zan_iest

Search took 9 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.593301333.9
2DLD Change Limit1486412087.79619066.3
3Display Results2082080.0962166.7
 (SQL Overall)1786912088.48521059.6
 
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.