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 “parbuckling” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

67 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
parbuckling225146(None) 
buckling17259113___buckling
parbaking1877203parb_ak_ing
parboiling1545173parb_oiling
parbuckle1942103parbuckl__e
parbuckled2151583parbuckl_ed
parbuckles2051913parbuckl_es
parceling1438443par__celing
prickling1836533p_r_ickling
ruckling15258573__r_uckling
truckling1645073_tr_uckling
unbuckling1942363_unbuckling
arcking145811964_ar__ck_ing
articling1247714_artic_ling
barbecuing1752324barbec_uing
barracking1944714barrack_ing
bucking163617574___buck_ing
cackling172610944ca___ckling
caracoling1545634car_acoling
carbureting1682954carbureting
carburising1653564carburising
carburizing2554124carburizing
carjacking2643544carjack_ing
chuckling2144194__chuckling
crackling18157004_cr_ackling
darkling1437484dar___kling
duckling16247704___duckling
freckling1934704_fr_eckling
garbling12249454garb___ling
garlicking1843054garlick_ing
hackling183310164ha___ckling
knuckling1542754__knuckling
mackling172710064ma___ckling
marbling13179884marb___ling
packing164420724pa___ck_ing
paddocking2142414paddock_ing
padlocking2043024padlock_ing
panbroiling1652564panbroiling
panicking1835294pa_nick_ing
paralleling1463104paralleling
parasailing1444334parasailing
parcelling1546174par_celling
parching164313054par__c_hing
parking143423044par___k_ing
parling103823764par____ling
paroling113316214par___oling
parqueting2243634parqu_eting
partaking1698674par_tak_ing
pickling17239204p___ickling
plucking17357724p__luck_ing
pricking173212604p_r_ick_ing
princeling1544654p_rinceling
rockling15259384__r_ockling
rucking143216674__r_uck_ing
runkling13217614__r_unkling
spackling18266504spa___ckling
sparkling16226354spar___kling
strickling1744954str_ickling
suckling152410024___suckling
swashbuckling287544swashbuckling
tackling153211124ta___ckling
tarmacking1944234tarmack_ing
trauchling1643474_trauchling
trickling1647724_tr_ickling
trucking153310164_tr_uck_ing
truckline1544914_tr_uckline
warbling14198944warb___ling

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 Filter1786911488190.423422437.4
2DLD Change Limit148819678.34317837.6
3Display Results67670.0302233.3
 (SQL Overall)178691678.79620315.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.