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

200 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
boubous113868(None) 
boubou1038421boubou_
bonbons1139332bonbons
booboos1138142booboos
bourbons1245342bourbons
boutons9310782boutons
brumous11107432brumous
buboes104513992b_uboes
bubus95115452b_ub_us
bulbous1138292bulbous
soukous1136402soukous
anurous7311553anurous
aqueous1636053aqueous
aurous64119263_aurous
baboos103517013b_aboos
babus95620333b_ab_us
balboas113710073balboas
bamboos1348753bamboos
batboys1465833batboys
baubees11348713baubees
baubles113611863baubles
bayous11411143b_ayous
bebops1237623b_ebops
bibulous1244633bibulous
bijous1548043b_ijous
bijugous1842223bijugous
bilboas11438723bilboas
bilboes114410233bilboes
bilbos105011193bilbo_s
bilious9310933bilious
bimboes13498723bimboes
bimbos124610513bimbo_s
blauboks1642293blauboks
blousons1054403blousons
blubs95818153blub__s
bobbers103614283bobbers
bobbies103714563bobbies
bobbins103410343bobbins
bobbles104514913bobbles
bobs86340643bo_b__s
boffos14568193boffo_s
bogus85616473bo__gus
bohos105618253bo_ho_s
boletus948643boletus
bolos75531373bo_lo_s
bolsons969483bolsons
bolus79125543bo__lus
bombers134512593bombers
bombes124916823bomb_es
bombs115818823bomb__s
bonbon10310073bonbo_n
bongoes104314113bongoes
bongos95316653bongo_s
bonobos1136393bonobos
bonus75324323bo__nus
boobies113718203boobies
booboo1039463boobo_o
boobs96221993bo__obs
boocoos1137753boocoos
boohoos1237993boohoos
bookoos1337503bookoos
books115729713bo__oks
booms95427123bo__oms
boons75031913bo__ons
boors74325013bo__ors
boos67955033bo__o_s
boots75837973bo__ots
borons85520543bo_rons
borrows12349253borrows
borzois1835833borzois
boshboks1943413boshboks
bosoms104913043bo_soms
bosons85016653bo_sons
bostons9312893bostons
bottoms1136983bottoms
boucles113113003boucles
boudins10311313boudins
boudoir1043843boudoir
boudoirs1143693boudoirs
bouffes15388633bouffes
boughs125414373bou_ghs
bougies103715183bougies
boules84925973bou_les
boulles93114123boulles
bounces113813683bounces
bounds94415803bou_nds
bounteous1144293bounteous
bourbon1135813bourbo_n
bourdons1136423bourdons
bourgs9459993bou_rgs
bournes93615023bournes
bourns84114063bou_rns
bourses94014303bourses
bouses84931783bou_ses
bousouki1451563bousouki
bousoukis1551623bousoukis
bouton8311533bouto_n
bouts75131313bou__ts
bouzouki2351203bouzouki
bouzoukis2451073bouzoukis
bowpots1446023bowpots
bowwows1454123bowwows
boyos105418283bo_yo_s
bozos165216863bo_zo_s
brulots946223brulots
bubals103513843b_ubals
bubbas94110703b_ubbas
bubkes144612623b_ubkes
bubo85621903b_ubo__
buboed113010003b_uboed
bubs86235493b_ub__s
bubu85022663b_ub_u_
bugout9311863b_ugout
bugouts1036193b_ugouts
bullous9311663bullous
buoys104810633b_u_oys
bupkus14385683b_upkus
burbots1168673burbots
burnous938823burnous
busboys14325023busboys
buyout11310103b_uyout
buyouts1235203b_uyouts
coccous1038993coccous
colobus11389373colobus
combos125316613combo_s
comous10816503co_mous
congous103615083congous
copious11311963copious
cormous11312353cormous
coupons112710553coupons
couscous1246663couscous
cowboys1735253cowboys
coypous14248813coypous
croupous1245903croupous
doubles103113353doubles
doubts968733doub_ts
dubious1036883_dubious
emulous937343emulous
fogbows1643853fogbows
folious103710733folious
fucous11399863_fucous
gibbous1265333gibbous
globous1036493globous
goboes95914443go_boes
gobos86219373go_bo_s
gombos114311093gombo_s
grumous1086603grumous
hoboes114717443ho_boes
hobos106321353ho_bo_s
iodous7311493io_dous
joyous16276763jo_yous
kobos115616893ko_bo_s
kombus1435523komb_us
kouros1039183kouro_s
lobos75921843lo_bo_s
lowboys1534213lowboys
lupous849433_lupous
moutons9410313moutons
mucous104411653_mucous
niobous936323niobous
nocuous946583nocuous
nodous7711323no_dous
nodulous944733nodulous
noxious1446563noxious
oboes75717713_o_boes
obols73715863_o_bols
obolus8378813_o_bolus
obvious1244813obvious
odious749933_odious
osmous8138183_osmous
ouzos143210413_ouzo_s
oxbows1833713_oxbows
plumbous1444283plumbous
poboys1397313po_boys
pompous1338063pompous
populous1245953populous
porous84419483po_rous
potboys1475273potboys
poyous112911623po_yous
raucous938283raucous
robots8313143ro_bots
roubles93413503roubles
rubious938273_rubious
rubout8313553_rubout
rubouts937973_rubouts
rubus76415053_rub_us
rufous948263_rufous
rugous739643_rugous
sombrous1246603sombrous
spumous1135853spumous
tomboys1435703tomboys
torous64319023to_rous
troublous1143943troublous
vodous1038593vo_dous
voudons1135313voudons
voudoun1143593voudoun
voudouns1243193voudouns
yobboes1445583yobboes
yobbos1335963yobbo_s
youpons12265983youpons

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.1561145455.1
2DLD Change Limit1340272006.29621287.6
3Display Results2002000.0603333.3
 (SQL Overall)1786912006.51227440.3
 
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.