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

103 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
bullpens125408(None) 
bullpen1135191bullpen_
bullets93516392bull_ets
bullies94121892bullie_s
bullions101710042bullions
mullens93611312mull_ens
autopens1046633autopens
baleens938473b_aleens
ballers94421013ball_ers
ballets93719513ball_ets
ballies93725743ballie_s
ballons93916963ball_ons
balloons103110523balloons
belleeks1444363belleeks
belles85325993bell_e_s
bellies94023723bellie_s
bellmen1138143bellmen_
billers94720833bill_ers
billets94516153bill_ets
billies93923503billie_s
billions102211793billions
billons93013363bill_ons
blypes13357543b_lype_s
boulles93114123boull_e_s
buckeens1634853buckeens
budless1038873budl_ess
buglers105115323bugl_ers
bugles94822443bugl_e_s
builders1146743builders
bulbels11398013bu_lbels
bulblets1255353bulblets
bulgers105215143bu_lgers
bulges95919323bu_lge_s
bullaces12299433bullaces
bullae83416163bullae__
bullbats1255893bullbats
bulldogs1274243bulldogs
bulled94626493bull_e_d
bullet84528613bull_e_t
bulletins1146333bulletins
bullhead1464783bullhead
bullheads1564283bullheads
bullhorns1443963bullhorns
bullied104514813bullie_d
bullier94116433bullie_r
bulliest104314503bulliest
bulling104324793bull_ing
bullion91911033bullion_
bullneck1642933bullneck
bullnecks1742273bullnecks
bullocks1636293bullocks
bullous9311663bull_ous
bullpout1245783bullpout
bullpouts1343193bullpouts
bullring11388423bullring
bullrings12314623bullrings
bulls75629573bull___s
bullweed1444753bullweed
bullweeds1543203bullweeds
bullying14329293bullying
bumpers133912053bu_mpers
burdens1039713bu_rdens
burlers94120273burl_ers
burleys12479673burl_eys
burthens1335383burthens
butlers94518053butl_ers
butles84423913butl_e_s
colleens1036843colleens
cullers93418853cull_ers
cullets94015613cull_ets
cullies94419963cullie_s
cullions10219223cullions
dullness934873dullness
ebullient1153953ebullient
fullers103817373full_ers
fullness1135443fullness
guldens9356573gu_ldens
gullets84013713gull_ets
gulleys11438523gull_eys
gullies84717313gullie_s
gulpers10299013gu_lpers
hullers103616263hull_ers
hulloes104113923hulloe_s
lullers73213353lull_ers
lumpens11298263lu_mpens
mulleins10277053mulleins
mullen83714763mull_en_
mullers93217303mull_ers
mullets93614783mull_ets
mulleys12299203mull_eys
mullions101910353mullions
plumpens14304953plumpens
pollens93713303poll_ens
pullers93618483pull_ers
pullets94015163pull_ets
pulleys12399143pull_eys
pullmans1253933pullmans
pulpers114612283pu_lpers
pulpless12224953pulpless
sullen62914293sull_en_
sullies74122233sullie_s
tulles63218893tull_e_s
unpens82511013_u_npens

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.420425454.8
2DLD Change Limit1461621037.28320068.9
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.74923059.9
 
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.