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

102 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
bucketing183571(None) 
bickering1837662bickering
bracketing1945232bracketing
bucking163617572buck__ing
bucklering1944042bucklering
buckling17259112buck_ling
budgeting1444022budgeting
buffeting1843782buffeting
bulleting1236642bulleting
bunkering16207102bunkering
docketing1785412docketing
jacketing2345642jacketing
junketing2143092junketing
packeting1836852packeting
picketing1835682picketing
pocketing1875852pocketing
puckering1835882puckering
racketing1647872racketing
rocketing1666972rocketing
socketing1666382socketing
suckering1638102suckering
ticketing1635632ticketing
tuckering1635692tuckering
accreting1446333accreting
backbiting2144293backbiting
backdating2045723backdating
backing165523443back__ing
backswing2144903backswing
basseting1236153basseting
becking164416073beck__ing
beckoning1845773beckoning
billeting1236643billeting
blackening1944793blackening
blanketing1743323blanketing
bonneting1236173bonneting
breveting1536263breveting
brokering1636283brokering
buckeen1536703bucke_en_
buckeens1634853bucke_ens
bucket144620733bucket___
bucketed1736763bucket_ed
bucketful2052083bucketful
buckets153811693bucket__s
buckraming2143113buckraming
buckskin1543573buckskin_
buckskins1643483buckskins
buffering1835223buffering
buggering1435193buggering
bulking143815123bulk__ing
bulletin1046773bulletin_
bulletins1146333bulletins
bumpering1636593bumpering
bunking144016193bunk__ing
bunkoing15355643bunk_oing
bunting103718833bu__nting
burdening1335543burdening
burking143716323burk__ing
bursting1138703bu_rsting
busheling1535503busheling
busking144116573busk__ing
busting104221793bu__sting
butchering1844503butchering
buttering122312523buttering
butting103519283bu__tting
cacheting1737153cacheting
casketing1635383casketing
cockering1839693cockering
cricketing1944033cricketing
cuckooing1843173cuckooing
curveting1535353curveting
dackering1737383dackering
dickering1737463dickering
ducking154315053duck__ing
duckling16247703duck_ling
ducting113713593duc__ting
dueting93814393du__eting
excreting1946433excreting
faceting1438783fac_eting
fucking173212283fuck__ing
gusseting1173963gusseting
hunkering17227123hunkering
jockeying2663293jockeying
lackering1639373lackering
lackeying1934923lackeying
lucking143615833luck__ing
marketing1636513marketing
mucking163213823muck__ing
nickeling1645393nickeling
nickering1636573nickering
nucleating1346943nucleating
quickening2643163quickening
quieting18228463qu_ieting
racheting1537793racheting
rucking143216673ruck__ing
ruckling15258573ruck_ling
russeting1065323russeting
secreting1279823secreting
sickening1635993sickening
sucking143217413suck__ing
suckling152410023suck_ling
tucking143415183tuck__ing
yucking173211693yuck__ing

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.440406115.9
2DLD Change Limit1486411027.36020195.8
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.84622774.8
 
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.