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

202 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
bulbous113829(None) 
bullous9311661bullous
balboas113710072balboas
bilboas11438732bilboas
bilboes114410242bilboes
bilbos105011202bilbo_s
bilious9310932bilious
boubous1138692boubous
buboes104513992bu_boes
bubus95115452bu_b_us
bulbels11398012bulbels
bulbils11338332bulbils
bulbously1643852bulbously
bulbs96016932bulb__s
bulbul10348072bulb_ul
bulbuls11346782bulbuls
burbots1168672burbots
burnous938822burnous
busboys14325022busboys
fulvous1334542fulvous
pulpous1177012pulpous
aurous64119263au_rous
autobus996513autobus
baboos103517013b_aboos
babus95620333b_ab_us
balboa10389963balbo_a
ballons93916963ballons
ballots94116033ballots
bamboos1348753bamboos
batboys1465833batboys
bayous11411153b_ayous
bebops1237623b_ebops
belabors1236403belabors
belabour1243773belabour
belabours1343543belabours
bellboys1544523bellboys
bellows124313303bellows
belons84119413bel_ons
belows114614183bel_ows
bibulous1244633bibul_ous
bijous1548043b_ijous
bilbies114712343bilbies
bilbo95513613bilbo__
bilboa10367843bilbo_a
billons93013363billons
billows123611293billows
bimboes13498733bimboes
bimbos124610523bimbo_s
blobs95620033b_l_obs
blocs95219653b_l_ocs
blogs85319233b_l_ogs
bloods94614843b_loods
blooms104613173b_looms
bloops106611343b_loops
blots75626173b_l_ots
blouse84714723b_l_ouse
blousy11459123b_l_ousy
blows105423833b_l_ows
blubs95818153blub__s
boletus948643boletus
bolos75531373bol_o_s
bolsons969483bolsons
bolus79125543bol__us
bonbons1139333bonbons
booboos1138143booboos
boubou1038433boubou_
bourbons1245343bourbons
brulots946223brul_ots
brumous11107443brumous
bubals103513843bu_bals
bubbas94110703bu_bbas
bubbies103913513bubbies
bubbles104315963bubbles
bubkes144612623bu_bkes
bubo85621913bu_bo__
buboed113010003bu_boed
bubs86235503bu_b__s
bubu85022673bu_b_u_
buckoes153810393buckoes
buckos143710893bucko_s
buffos14447853buffo_s
bugaboos1343403bugaboos
bughouse1445073bughouse
bugloss1035893bugloss
bugout9311863bu_gout
bugouts1036193bu_gouts
bulb85626693bulb___
bulbar1039583bulb_ar
bulbed114312773bulb_ed
bulbel104510683bulb_el
bulbil10389573bulb_il
bulblet11311213bulblet
bulblets1255353bulblets
bulgers105215143bulgers
bulges95919323bul_ges
bulghur1352723bulghur
bulghurs1452763bulghurs
bulgur9387533bul_gur
bulgurs10397113bulgurs
bulks115920613bul__ks
bullbats1255893bullbats
bulldogs1274243bulldogs
bullets93516393bullets
bullies94121893bullies
bullions101710043bullions
bullock1537193bullock
bullocks1636293bullocks
bullpout1245783bullpout
bullpouts1343193bullpouts
bullrush1342793bullrush
bulls75629573bul__ls
bullyboys1942263bullyboys
bulrush1243593bul_rush
bumbles134016843bumbles
bumboat1349023bumboat
bumboats1445183bumboats
buncos104011593bunco_s
bunions92210473bunions
bunkos124210323bunko_s
buoys104810633bu__oys
bupkus14385683bu_pkus
burbles114916803burbles
burbot10815653burbo_t
burbs95423493burb__s
bureaus979293bureaus
burgoos1037123burgoos
burgout1049773burgout
burgouts1145123burgouts
burnout9310453burnout
burnouts1045263burnouts
burros85114993burro_s
burrows12399093burrows
burtons9310853burtons
busbars1138153busbars
busbies113011693busbies
busboy13307443busbo_y
buteos84913413buteo_s
buttons9310333buttons
butyrous1345443butyrous
buyout11310103bu_yout
buyouts1235203bu_youts
callous93516603callous
colobus11389373colobus
cultus85110733cul_tus
cumbrous1446173cumbrous
cuprous1149743cuprous
curious93813563curious
dubious1036893dubious
dumbos114111083dumbo_s
duteous838453duteous
elbows1196713_elbows
emulous937343emul_ous
fabulous1344853fabul_ous
folious103710733folious
fucous11399863fu_cous
fungous11367433fungous
furious103110633furious
fuscous1256673fuscous
gallous82813953gallous
gibbous1265333gibbous
globous1036503globous
gumbos114610873gumbo_s
gummous1236263gummous
hugeous1137133hugeous
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
jumbos17379123jumbo_s
lulus54315163lul__us
lupous849433lu_pous
luteous739273luteous
mucous104411653mu_cous
nebulous1045093nebul_ous
niobous936333niobous
pileous9510523pileous
pilous84717753pil_ous
plumbous1444283plumbous
pullout9310593pullout
pullouts1045223pullouts
rubious938283rubious
rubout8313563ru_bout
rubouts937983ru_bouts
rubus76415063ru_b_us
rufous948273ru_fous
rugous739653ru_gous
ruinous739763ruinous
sabulous1046123sabul_ous
sublots92410913sublots
sulcus8410493sul_cus
sulus54821883sul__us
sunbows1236023sunbows
talcous939483talcous
tubulous1045373tubul_ous
turbos8910783turbo_s
turbots988023turbots
ulus45622563_ul__us
umbos94613073_umbo_s
upbows1384683_upbows
uveous936603_uveous
villous102810023villous
vulgus1035783vul_gus

Search took 7 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.406440125.6
2DLD Change Limit1340272026.36021073.4
3Display Results2022020.0802525.0
 (SQL Overall)1786912026.84626101.5
 
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.