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

106 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
burbliest136559(None) 
bubbliest1254421bubbliest
burliest103113061bur_liest
bubblies1166772bubblies_
bulliest104314502bu_lliest
burbles114916802burbl_es_
burblier1255602burblie_r
burriest102911212bur_riest
curliest102713122cur_liest
marbliest1336762marbliest
nubbliest1354362nubbliest
rubbliest1354692rubbliest
surliest82416912sur_liest
auntliest936323auntliest
babiest114414753b_ab_iest
bairnliest1242623bairnliest
barbies114519593barb_ies_
barbless12318713barbl_ess
barflies1338303barflies_
barkiest144115153bar_kiest
barmiest125212783bar_miest
barniest104815053bar_niest
biblist11310833b_ibli_st
blurbist1245493blurb_i_st
blurriest1155153blur_riest
brakiest143912243b_rakiest
brambliest1643773brambliest
brawliest14177193brawliest
briniest102812323b_riniest
brushiest14297543brushiest
bubbies103913513bu_bbies_
bubbles104315963bubbl_es_
bubblier1184473bubblie_r
buffiest1657563bu_ffiest
buggiest123410363bu_ggiest
bulblet11311213bulbl_e_t
bulblets1255353bulbl_ets
bulgiest112910943bu_lgiest
bulkiest143511263bu_lkiest
bullies94121893bu_llies_
bumbles134016843bumbl_es_
bumpiest1437873bu_mpiest
bunchiest1635663bunchiest
burble104617703burbl_e__
burbled124312673burbl_e_d
burbler114412423burbl_e_r
burblers12399263burbl_ers
burbling13249423burbli_ng
burdies104117563bur_dies_
burgles105615963burgl_es_
buries84633273bur__ies_
burlesk1335463bur_l_esk
burlier93514413bur_lie_r
burliness1137833bur_liness
burnies94017823bur_nies_
busbies113011693busb_ies_
bushiest133512523bu_shiest
busiest93716303bu__siest
bustiest102815053bu_stiest
courtliest1244903courtliest
crumbliest1643903crumbliest
cuddliest1343333cuddliest
curdiest112511393cur_diest
curviest13309673cur_viest
darkliest1435163darkliest
drumliest1235433drumliest
earliest82415243ear_liest
fubsiest13258413fu_bsiest
furriest112910793fur_riest
furziest20267783fur_ziest
girliest93010403gir_liest
grubbiest1434253grubbiest
herbiest1339993herb_iest
humblest15288283humbl_est
hurlies103315333hur_lies_
jungliest1744923jungliest
knurliest1344073knur_liest
lordliest1036103lordliest
marliest102415183mar_liest
muralist10312983murali_st
murkiest143210263mur_kiest
nubbiest12117313nu_bbiest
orbiest9312413_orb_iest
pebbliest1543713pebbliest
portliest11310183portliest
puddliest1343693puddliest
purplest12249133purpl_est
pursiest102812123pur_siest
purtiest102414113pur_tiest
rubiest92914423ru_b_iest
ruffliest1554493ruffliest
ruliest72816433__ruliest
rumpliest1345313rumpliest
ruralist8311703rurali_st
stubbliest1453343stubbliest
sublimest1346713su_blimest
surfiest112414433sur_fiest
tubbiest12117293tu_bbiest
turfiest112410133tur_fiest
ugliest8410153_u_gliest
unblest9411813_unbl_est
unruliest945873unruliest
urbanest10117533_urbanest
wabbliest16274963wabbliest
wambliest16255153wambliest
wobbliest16275333wobbliest

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.420425454.8
2DLD Change Limit1486411066.90621523.5
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.37224239.1
 
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.