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

111 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
bobsleds1330438(None) 
bobsled12297151bobsled_
bobbled113811832bobbled_
bobbles104514912bobble_s
dogsleds1142912dogsleds
babbled113612863babbled_
babblers113510353babblers
babbles104416323babble_s
bibles104617643bib_le_s
bibless11439173bib_less
bilsteds1134273bilsteds
boasted104113743boasted_
boasters103915663boasters
bobbed104315833bob_bed_
bobbers103614283bob_bers
bobbies103714563bobbie_s
bobble94115143bobble__
bobsledded1751543bobsledded
bobsledder1651713bobsledder
bobsledders1751503bobsledders
bobsleigh1751723bobsleigh
bobsleighs1851143bobsleighs
bobstays1543343bobstays
bodiless1135913bodiless
boggled12409003boggled_
bogglers12347603bogglers
boggles113411823boggle_s
bogles95020833bo_gle_s
boiled95020953bo_iled_
boilers93417063bo_ilers
bolds85825283bo__l_ds
boles75448603bo__le_s
bolled94722653bo_lled_
bolsters103712453bolsters
boltless10338283boltless
bomblets1436023bomblets
bondless1148813bondless
boneless10310213boneless
boodled113410933boodled_
boodlers113710743boodlers
boodles103416043boodle_s
booklets14247123booklets
boomlets12246673boomlets
boonless10328353boonless
boosted104111983boosted_
boosters104013443boosters
bootlegs11325873bootlegs
bootless103410983bootless
boshes114721883bo_she_s
boskets13409473bo_skets
bossed94816533bo_ssed_
bosses85925403bo_sse_s
bossies94116833bossie_s
bottled104611233bottled_
bottlers103810013bottlers
bottles94216273bottle_s
boucles113113003boucle_s
boules84925973bo_ule_s
boulles93114123boulle_s
boused95322883bous_ed_
bouses84931783bous_e_s
boweled132810693boweled_
bowled125018143bo_wled_
bowlegs13366823bo_wlegs
bowlers123715783bo_wlers
bowless123310313bo_wless
bowsed125715973bows_ed_
bowses115718863bows_e_s
bubales113513343bubale_s
bubbled113612123bubbled_
bubblers11448943bubblers
bubbles104315963bubble_s
bugseeds1242843bugseeds
burseeds1134783burseeds
cobbled143411633cobbled_
cobblers14359593cobblers
cobbles133814823cobble_s
cobles104622883cob_le_s
corslets1038273corslets
cowsheds1734743cowsheds
dogsled1035193dogsled_
gobbled134010253gobbled_
gobblers13308343gobblers
gobbles123512583gobble_s
goblets103210183gob_lets
hobbled153310783hobbled_
hobblers15308513hobblers
hobbles143313783hobble_s
jobless16237563job_less
kobolds1474343kobol_ds
lobsters10268743lobsters
lobules92510813lobule_s
lossless835473lossless
mobiles112813123mobile_s
mobled113213183mob_led_
mobsters12359063mobsters
nobbled123511283nobbled_
nobblers12318563nobblers
nobbles114014523nobble_s
nobles83319723nob_le_s
nonskeds1343933nonskeds
oboles83815833_obole_s
obsess845943_obs_ess
robles85321693rob_le_s
sleds64418853___sleds
tousled84710363tousled_
tousles74113933tousle_s
wobbled15349593wobbled_
wobblers15327883wobblers
wobbles143412433wobble_s
worsteds1234483worsteds

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621117.25320151.9
3Display Results1111110.0303700.0
 (SQL Overall)1786911117.68923239.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.