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

175 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
shackling1928617(None) 
hackling183310161_hackling
shacking184014081shack_ing
spackling18266491spackling
cackling172610942_cackling
chuckling2144192chuckling
crackling18157002crackling
hacking173720612_hack_ing
heckling18257162_heckling
mackling172710062_mackling
sacking144122702s_ack_ing
shaking153317252sha_k_ing
shambling1735592shambling
shanking163612282shank_ing
sharking163912972shark_ing
shauling1249392sha_uling
shaveling1646842shaveling
shawling1558222sha_wling
shocking184311532shock_ing
shucking18339432shuck_ing
sickling152910332s_ickling
slacking153914132slack_ing
smacking173510762smack_ing
snacking153411702snack_ing
sparkling16226342sparkling
speckling18235582speckling
stacking154215082stack_ing
stickling1647002stickling
suckling152410022s_uckling
tackling153211122_tackling
thacking183110042thack_ing
unshackling2141652unshackling
whacking21377482whack_ing
ankling122912063__ankling
backing165523443_back_ing
blacking174213603black_ing
buckling17259113_buckling
chalking183310063chalk_ing
charking183512613chark_ing
checking20379203check_ing
chocking204011013chock_ing
chucking20379503chuck_ing
clacking173313493clack_ing
cockling172310393_cockling
cracking174013903crack_ing
cracklings19143523cracklings
crankling16147293crankling
darkling1437483_darkling
duckling16247703_duckling
flacking184311793flack_ing
freckling1934703freckling
hacklier1737133_hacklier
haggling14227273_haggling
hailing113820693_ha_iling
haling104229783_ha__ling
handling132312713_handling
hanking154619103_hank_ing
harking154120943_hark_ing
hassling1236803_hassling
hatchling1844953_hatchling
hauling113714433_ha_uling
hawking183711423_hawk_ing
hocking173417243_hock_ing
jacking214515263_jack_ing
keckling14245523_keckling
knacking14296713knack_ing
knuckling1542753knuckling
lacking143821543_lack_ing
maculing13219583_maculing
nickling15278703_nickling
packing164420723_pack_ing
pickling17239203_pickling
prickling1836533prickling
quacking2436743quack_ing
racking144323663_rack_ing
rankling132610113_rankling
retackling1744433retackling
rockling15259383_rockling
ruckling15258573_ruckling
sackings15389633s_ack_ings
sacklike1337303s_acklike
sacring103115983s_ac_ring
saddling11239593s_addling
sailing83927373s_a_iling
sampling13510643s_ampling
sandling102214413s_andling
sapling103217863s_a_pling
scabbling1634863scabbling
scaling103519373s__caling
scantling12107233scantling
sealing83528563sea__ling
shackle16409543shackl__e
shackled18277593shackl_ed
shackler17317973shackl_er
shacklers18336033shacklers
shackles173010593shackl_es
shading123115563sha__ding
shadowing1744263shadowing
shafting15278673sha_fting
shagging14349053sha_gging
shaming133016743sha__ming
shamming16289413sha_mming
shammying2042953shammying
shamoying1844523shamoying
shaping133116183sha__ping
sharing113723243sha__ring
sharklike1543923sharklike
sharping143011373sha_rping
shavelings1743503shavelings
shaving143414333sha__ving
shawing143514883sha__wing
shealing123415463sh_ealing
shearling1336923shearling
shelling123515213sh_elling
shieling123512403sh_ieling
shilling123315373sh_illing
shingling14136953shingling
shirking163210473shirk_ing
shoaling123111743sh_oaling
shooling123012553sh_ooling
shoveling1635553shoveling
shrilling13307693shrilling
shuckings19273853shuck_ings
shuffling1933443shuffling
shuttling1334283shuttling
sicking143720173s_ick_ing
sicklying1943883s_icklying
skanking12288743skank_ing
slackening1744343slackening
slaking123717473sla_k_ing
slicking153712593slick_ing
smocking17349103smock_ing
snaffling1643753snaffling
snailing92912973sna_iling
snaking123915303sna_k_ing
snarling92513183sna_rling
snicking153610233snick_ing
soaking123116613soa_k_ing
socking143518603s_ock_ing
spacing123614493spac__ing
spalling113213463spa_lling
spanceling1543943spanceling
spangling1336373spangling
spanking153911973spank_ing
sparking152812533spark_ing
sparling112714523spa_rling
specking17359733speck_ing
stabling112913653sta_bling
staking123919803sta_k_ing
staling83925423sta__ling
stalking133512223stalk_ing
stalling95116693sta_lling
stapling112813153sta_pling
starling93017123sta_rling
startling1037373startling
sticking153513463stick_ing
stocking152912503stock_ing
strickling1744953strickling
sucking143217413s_uck_ing
sucklings16225113s_ucklings
swaddling1543813swaddling
swanking16399963swank_ing
tacking144421483_tack_ing
tacklings16235853_tacklings
thanking16409523thank_ing
thwacking2253193thwack_ing
tickling15309433_tickling
trachling1537823trachling
tracking153715463track_ing
trickling1647723trickling
truckling1645073truckling
weakling16106763wea_kling
whaling143910773wha__ling
wracking18349963wrack_ing
yacking174315683_yack_ing

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.1731032896.0
2DLD Change Limit1486411758.03018510.7
3Display Results1751750.0802187.5
 (SQL Overall)1786911758.28321573.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.