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

113 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
bugbears133369(None) 
bugbear1233951bugbear_
bogbeans1343452bogbeans
buggers114315662bugge_rs
buglers105115322bugle_rs
busbars1138152busb_ars
cudbears1343482cudbears
unbears998042_unbears
upbears1195422_upbears
antbears1044963antbears
augers73818703aug_e_rs
baggers113915693bagge_rs
barbers114317503barbe_rs
bears75739043___bears
beggars11378223beg_gars
besmears1234543besmears
bibbers103911353bibbe_rs
bigheads15145653bigheads
blears85116453b__lears
blubbers11408143blubbe_rs
bluebeard1442683bluebeard
bluebeards1542293bluebeards
bluebeats1343463bluebeats
bobbers103614283bobbe_rs
bogbean1244643bogbea_n
bombers134512593bombe_rs
bribers114111503bribe_rs
bubals103513843bu_b_als
bubbas94110703bu_bba_s
bubblers11448943bubblers
buckbeans19102943buckbeans
buckers153517453bucke_rs
budders113812103budde_rs
budgers114314923budge_rs
buffers153310793buffe_rs
bugbane1255863bugb_ane
bugbanes1345153bugbanes
bugeyes1335513bug_eyes
bugger104418723bugge_r_
buggery14367933bugge_ry
bugler94717723bugle_r_
bugles94822443bugle__s
bugseeds1242843bugseeds
bugshas1334513bugsha_s
bulbar1039583bulb_ar_
bulbels11398013bulbe_ls
bulgers105215143bulge_rs
bumblers143710733bumblers
bumboats1445183bumboats
bummers133712443bumme_rs
bumpers133912053bumpe_rs
bunglers11398483bungle_rs
bunkers133715953bunke_rs
bunters94717123bunte_rs
burblers12399263burblers
bureaus979293bu_reaus
burgers103918573burge_rs
burghers1435633burghe_rs
burglars1154593burglars
buriers94017193burie_rs
burkers133716623burke_rs
burlers94120273burle_rs
burners94115673burne_rs
burrers93814493burre_rs
bursars94510893bu_rsars
busbar1038453busb_ar_
bushers124018803bushe_rs
buskers133414093buske_rs
busters94724133buste_rs
butlers94518053butle_rs
butters94521723butte_rs
buyers114511003bu_ye_rs
buzzers17347173buzze_rs
cubers105318353cu_be_rs
cudbear1233333cudbear_
cumbers134515413cumbe_rs
curbers115514383curbe_rs
dogears937513dog_ears
dubbers124011823dubbe_rs
durbars1077973durb_ars
forbears1337073forbears
gears64628693__g_ears
huggers124211593hugge_rs
jugheads2042923jugheads
jugulars1643233jugulars
lubbers113913723lubbe_rs
lugers74617023lug_e_rs
luggers93713483lugge_rs
lumbars11289763lumb_ars
lumbers113815913lumbe_rs
muggars11316643mug_gars
muggers113611933mugge_rs
numbers113711243numbe_rs
outbeams1236063outbeams
outhears11810393outhears
outwears1197263outwears
regears83012463reg_ears
rubbers113913193rubbe_rs
ruggers94612313rugge_rs
subers85722643su_be_rs
sugars7312423sug__ars
sunbeams1243963sunbeams
tubbers113411253tubbe_rs
tubers85017033tu_be_rs
tugboats11154103tugboats
tuggers93711443tugge_rs
umbers104215213_umbe_rs
unbars82113033_unb_ars
unbear889163_unbear_
upbear1096493_upbear_
upbeats1195733_upbeats
uprears9107493_uprears
uptears9106453_uptears

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621137.53019410.6
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.98222386.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.