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

128 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
bugbear123395(None) 
bugbears1333691bugbears
bogbean1244642bogbean
bugger104418722bugge_r
bugler94717722bugle_r
bulbar1039582bulb_ar
busbar1038452busb_ar
cudbear1233332cudbear
unbear889162_unbear
upbear1096492_upbear
antbear935063antbear
auger64922473aug_e_r
bagger104619203bagge_r
barber104419323barbe_r
bear66844643___bear
beggar10328223beg_gar
besmear1134833besmear
bibber94613573bibbe_r
bigger104315063bigge_r
bighead14126653bighead
blear75918683b__lear
blubber10399293blubbe_r
bluebeard1442683bluebeard
bluebeat1245533bluebeat
bobber95016743bobbe_r
bogbeans1343453bogbeans
bomber125014653bombe_r
briber104714043bribe_r
bubal94218213bu_b_al
bubba84311803bu_bba_
bubbas94110703bu_bbas
bubbler103611783bubbler
buckbean18113203buckbean
bucker145420463bucke_r
budder104314813budde_r
budger104617703budge_r
buffer144512683buffe_r
bugbane1255863bugbane
bugeye1236533bug_eye
bugged114318403bugge_d
buggers114315663buggers
buggery14367933buggery
buggier113611343buggier
bugle84721943bugle__
bugled104918133bugle_d
buglers105115323buglers
bugles94822443bugle_s
bugseed1136173bugseed
bugsha1233823bugsha_
bugshas1334513bugshas
bulbed114312773bulbe_d
bulbel104510683bulbe_l
bulbels11398013bulbels
bulger94917353bulge_r
bulgier103911213bulgie_r
bumbler134013233bumbler
bumboat1349023bumboat
bummer124014103bumme_r
bumper123714343bumpe_r
bungler104611483bungle_r
bunker124519373bunke_r
bunter85020383bunte_r
burbler114412423burbler
bureau8712523bu_reau
burger94020793burge_r
burgher1337003burghe_r
burglar1065533burglar
burier84324653burie_r
burker125221173burke_r
burler84723833burle_r
burner83819203burne_r
burrer83718473burre_r
bursar85413253bu_rsar
bursera936763bursera
busbars1138153busb_ars
busher114922203bushe_r
busier85219723busie_r
busker125517833buske_r
buster84726493buste_r
butler84220033butle_r
butter84724233butte_r
buyer105013093bu_ye_r
buzzer16379113buzze_r
cuber95222533cu_be_r
cudbears1343483cudbears
cumber124016703cumbe_r
curber104517053curbe_r
dogear838193dog_ear
dubber113814553dubbe_r
dumber114414173dumbe_r
durbar968723durb_ar
forbear1237523forbear
fubar1039923fu_b_ar
gear55934973__g_ear
huger94914873hug_e_r
hugger114713123hugge_r
jughead1933643jughead
jugular1534513jugular
lubber104214623lubbe_r
luger65322083lug_e_r
lugger83916553lugge_r
lumbar103610593lumb_ar
lumber103817773lumbe_r
muggar10316443mug_gar
mugger103914703mugge_r
nuclear936233nuclear
number103913223numbe_r
outbeam1137973outbeam
outhear10910603outhear
outwear1097713outwear
regear73512743reg_ear
rubber104715793rubbe_r
rugger84414513rugge_r
suber74924503su_be_r
subpar1048663su_bpar
sugar6312913sug__ar
sunbeam1146053sunbeam
tubber104313203tubbe_r
tuber75420683tu_be_r
tugboat10126103tugboat
tugger84013103tugge_r
umber94617593_umbe_r
unbar71913613_unb_ar
unbears998043_unbears
upbears1195423_upbears
upbeat10911513_upbeat
uprear8168793_uprear
uptear896783_uptear

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.1401276364.3
2DLD Change Limit1340271286.40620922.1
3Display Results1281280.0462782.6
 (SQL Overall)1786911286.59227107.3
 
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.