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

150 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
bullpen113519(None) 
bullpens1254081bullpens
bellmen1138142bellmen
bullae83416162bullae_
bulled94626492bull_ed
bullet84528612bull_et
bullied104514812bullied
bullier94116432bullier
bullies94121892bullies
bullion91911032bullion
mullen83714762mull_en
sullen62914292sull_en
autopen947123autopen
baleen8613053b_aleen
balled94926893ball_ed
baller83825203ball_er
ballet84733973ball_et
ballies93725743ballies
ballon84117493ball_on
balloon93711433balloon
belle75827833bell_e_
belled94626183bell_ed
belleek1347243belleek
belles85325993bell_es
bellied104314073bellied
bellies94023723bellies
bellman1137183bellman
billed94224903bill_ed
biller84923483bill_er
billet86029723bill_et
billie85019173billie_
billies93923503billies
billion92212163billion
billon83713823bill_on
blype12429673b_lype_
blypes13357543b_lypes
bolled94722653boll_ed
boulle84614613boull_e_
boulles93114123boull_es
buckeen1536703buckeen
bugle84721943bugl_e_
bugled104918133bugl_ed
bugler94717723bugl_er
bugles94822443bugl_es
builded1136473builded
builder1037573builder
bulbed114312773bu_lbed
bulbel104510683bu_lbel
bulblet11311213bulblet
bulge86419873bu_lge_
bulged105117123bu_lged
bulger94917353bu_lger
bulges95919323bu_lges
bulgier103911213bulgier
bulked134216743bu_lked
bulkier134111513bulkier
bull65634873bull___
bulla74620563bull__a
bullace113410673bullace
bullaces12299433bullaces
bullate93415073bullate
bullbat1158553bullbat
bulldog1174253bulldog
bulleted1138393bulleted
bulletin1046773bulletin
bullets93516393bullets
bullhead1464783bullhead
bullhorn1344453bullhorn
bulliest104314493bulliest
bulling104324793bulling
bullions101710033bullions
bullish12511193bullish
bullneck1642933bullneck
bullock1537193bullock
bullous9311663bullous
bullpout1245783bullpout
bullring11388423bullring
bulls75629573bull__s
bullweed1444753bullweed
bully105124813bull__y
bullying14329293bullying
bumped134414003bu_mped
bumper123714343bu_mper
burden9412473bu_rden
burled94825383burl_ed
burler84723833burl_er
burley114715753burl_ey
burlier93514413burlier
burped116215503bu_rped
burthen1236363burthen
bushmen1436303bushmen
busmen1039893bu_smen
butle75023103butl_e_
butled94818603butl_ed
butler84220033butl_er
butles84423913butl_es
colleen939533colleen
culled94022473cull_ed
culler84322253cull_er
cullet84727313cull_et
cullied104012353cullied
cullies94419963cullies
cullion91910233cullion
dulled84719423dull_ed
duller74017703dull_er
ebullient1153953ebullient
fallen93813373fall_en
fulled103820653full_ed
fuller94220383full_er
gulden8328763gu_lden
gulled84521373gull_ed
gullet74924833gull_et
gulley104213163gull_ey
gullied93812063gullied
gullies84717313gullies
gulped104610373gu_lped
gulper93410213gu_lper
holpen11299413_holpen
hulled103920013hull_ed
huller93919103hull_er
hulloed11369793hulloed
hulloes104113923hulloes
lulled74516443lull_ed
luller63415483lull_er
lumpen104010663lu_mpen
mulled94721553mull_ed
mullein9278563mullein
mullens93611313mull_ens
muller83820353mull_er
mullet84126823mull_et
mulley114013453mull_ey
mullion91911173mullion
nulled74318273null_ed
plumpen13276403plumpen
pollen83416453poll_en
pulled94322193pull_ed
puller83820813pull_er
pullet84026333pull_et
pulley113713403pull_ey
pullman1135403pullman
pulped114612533pu_lped
pulper103513273pu_lper
sullied83714483sullied
sullies74122223sullies
tollmen935733tollmen
tulle54019933tull_e_
tulles63218893tull_es
ulpan7310123_u_lpan
unopen838913_unopen
unpen72913573_u_npen

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 Filter1786911340270.280638182.1
2DLD Change Limit1340271508.25016245.7
3Display Results1501500.0632381.0
 (SQL Overall)1786911508.59320794.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.