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

222 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
crankling1614729(None) 
crackling18157001crackling
cranking154613071crank_ing
crinkling16145861crinkling
rankling132610111_rankling
ankling122912062__ankling
brandling1348252brandling
cackling172610942c_ackling
canaling112016412c_analing
candling122313872c_andling
clanking154313062clank_ing
craaling112711352cra_aling
cracking174013902crack_ing
cracklings19143522cracklings
cradling122411452cra_dling
cranching17278732cranching
craning103620302cran__ing
crankpin16103752crankpin_
crankpins17133762crankpins
crawling143110512cra_wling
creneling1247732creneling
franking164310862frank_ing
franklin15104602franklin_
franklins1694762franklins
pranking153813382prank_ing
ranking124320882_rank_ing
runkling13217612_runkling
wrangling1456222wrangling
wrinkling17144952wrinkling
aneling82719503__aneling
angling92816043__angling
banking144621353_bank_ing
bantling112612003_bantling
blanking154411933blank_ing
brabbling1334963brabbling
brailing113514793bra_iling
brailling1247773brailling
braking143917713bra_k_ing
brambling1635543brambling
branching17289263branching
branding122513683bran_ding
brandlings1443993brandlings
brandying1654883brandying
branning112911093bran_ning
brattling1236003brattling
brawling143210043bra_wling
cabling124017553c_a_bling
cageling12310843c_ageling
cajoling18318423c_ajoling
caking134624673c_a_k_ing
calking144617783c_alk_ing
calling103826773c_a_lling
canalling1239553c_analling
canceling14310163c_anceling
candying15188993c_andying
caning94128623c_an__ing
cankering162110793c_ankering
canning103620133c_an_ning
canoeing11310213c_anoeing
canting104725903c_an_ting
caracoling1545633caracoling
carking144322853c_ark_ing
carling103727063c_a_rling
caroling113317003c_aroling
carolling1259413carolling
casking144317353c_ask_ing
castling11311233c_astling
catling104819793c_a_tling
caulking1536803c_aulking
caviling14310113c_aviling
chalking183310063chalk_ing
chancing162810283chan_cing
changeling1745673changeling
changing153211513chan_ging
channeling1645203channeling
chanting143413533chan_ting
charking183512613chark_ing
chinking183210893chink_ing
chuckling2144193chuckling
chunking18328053chunk_ing
clacking173313493clack_ing
clanging124012123clan_ging
clinking153611663clink_ing
clonking153810153clonk_ing
clunking15329433clunk_ing
coaling103722823coa__ling
cockling172310393c_ockling
conking143618453c_onk_ing
crabbing15287933cra_bbing
crackings18346843crack_ings
cracklier1744823cracklier
crafting143710173cra_fting
cramming15339433cra_mming
cramping153411853cra_mping
crankier14339163crank_ier
crankily1755623crank_ily
crankish1736513crank_ish
crankle133610063crankl__e
crankled15408153crankl_ed
crankles143510153crankl_es
crankly16358123crankl__y
craping124018713cra__ping
crapping153911453cra_pping
crashing143512633cra_shing
cratering12312653cratering
crating103725203cra__ting
craunching1843313craunching
cravening1547553cravening
craving134015733cra__ving
crayoning1535243crayoning
crazing193914583cra__zing
creaking153414123creak_ing
creeling113513363cr_eeling
crenelling1345683crenelling
cricking173412653crick_ing
crimpling1645343crimpling
cringing123311383crin_ging
crinklier1543843crinklier
crinoline1147773crinoline
crippling1644093crippling
croaking153712163croak_ing
crocking174313443crock_ing
crooking153611343crook_ing
crumbling1655083crumbling
crumpling1645323crumpling
crunching17297003crunching
cyaniding1644803cyaniding
dandling112511733_dandling
dangling112611233_dangling
darkling1437483_darkling
drabbling1544553drabbling
draggling1354613draggling
drawling13318673dra_wling
drinking14308913drink_ing
eanling81416673_ean_ling
flanking164211083flank_ing
frazzling2143153frazzling
freckling1934703freckling
gangling112411403_gangling
grabbling1564583grabbling
granting103514523gran_ting
grappling1544993grappling
graveling1457383graveling
grayling1338003gra_yling
gruntling1134263gruntling
hackling183310163_hackling
handling132312713_handling
hanking154619103_hank_ing
inkling122911303__inkling
jangling17249623_jangling
kraaling13186663kra_aling
mackling172710063_mackling
mangling122312623_mangling
mantling112012613_mantling
paneling111013623_paneling
planking153513013plank_ing
prancing132612163pran_cing
pranging123012723pran_ging
prattling1246303prattling
prickling1836533prickling
prinking153212453prink_ing
rabbling13239333_rabbling
racking144323663_rack_ing
raddling11229773_raddling
raffling1567063_raffling
railing83325643_ra_iling
raking114728423_ra_k_ing
rambling131810773_rambling
ranching141712043_ranching
ranging94120263_ran_ging
rankings13389173_rank_ings
ranting84025413_ran_ting
rassling939013_rassling
rattling92510873_rattling
raveling123414373_raveling
rockling15259383_rockling
ruckling15258573_ruckling
sandling102214413_sandling
scantling12107233scantling
scrabbling1742853scrabbling
scrambling1743473scrambling
scrawling15195583scra_wling
shackling19286173shackling
shanking163612283shank_ing
skanking12288743skank_ing
spackling18266503spackling
spangling1336373spangling
spanking153911973spank_ing
sparkling16226353sparkling
sprinkling1743823sprinkling
strangling1256403strangling
swanking16399963swank_ing
tackling153211123_tackling
tangling101712543_tangling
tanking123918793_tank_ing
thanking16409523thank_ing
tinkling13239233_tinkling
trachling1537823trachling
tracking153715463track_ing
traiking132511973traik_ing
trailing92916093tra_iling
trameling1249053trameling
trampling1436973trampling
trancing112812023tran_cing
traveling1349053traveling
trawling122710783tra_wling
trickling1647723trickling
trindling1137133trindling
truckling1645073truckling
trundling1135003trundling
twangling1434453twangling
twinkling1743643twinkling
wangling132310993_wangling
wanking154216783_wank_ing
weakling16106763wea_kling
weanling12118643wean_ling
winkling16298293_winkling
wracking18349963wrack_ing
wrassling1334273wrassling
wrastling1335523wrastling
yanking154512463_yank_ing
yeanling12107063yean_ling

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.423422437.4
2DLD Change Limit1486412227.43619989.4
3Display Results2222220.0932387.1
 (SQL Overall)1786912227.95222471.2
 
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.