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

183 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
boubou103843(None) 
boubous1138691boubous
bonbon10310072bonbon
booboo1039462booboo
bourbon1135812bourbon
bouton8311532bouton
bubo85621912b_ubo_
bubu85022672b_ub_u
baboo94319503b_aboo
babu85829233b_ab_u
balboa10389963balboa
bamboo12310013bamboo
batboy1387533batboy
baubee103215993baubee
bauble103813213bauble
bayou10512363b_ayou
bebop11410793b_ebop
bijou1458793b_ijou
bilbo95513613bilbo_
bilboa10367843bilboa
bilbos105011203bilbos
bimbo114811873bimbo_
bimbos124610523bimbos
blaubok1542243blaubok
blouson974893blouson
blub85324873blub__
blubs95818153blub_s
bob76755673bo_b__
bobbed104315833bobbed
bobber95016743bobber
bobbin93410733bobbin
bobble94115143bobble
bobby114814663bo_bby
bobs86340653bo_b_s
boffo136010373boffo_
boffos14568193boffos
boho96923323bo_ho_
bohos105618253bo_hos
bollox1548743bollox
bolo65535953bo_lo_
bolos75531373bo_los
bolson8410683bolson
bomb106927423bomb__
bombax1935753bombax
bombe115519313bomb_e
bombed134113873bombed
bomber125014653bomber
bombes124916823bombes
bombs115818823bomb_s
bombyx2232693bombyx
bonbons1139333bonbons
bongo85720943bongo_
bongos95316653bongos
bonobo1037143bonobo
bonobos1136393bonobos
boo58163663bo__o_
boob85932583bo__ob
boobed114514873boobed
boobie104015293boobie
booboos1138143booboos
boobs96221993boob_s
booby125319513boob_y
boocoo1039003boocoo
boohoo1148833boohoo
book106836333bo__ok
bookoo1248343bookoo
boom87435673bo__om
boombox2073613boombox
boon67142173bo__on
boor66130683bo__or
boos67955033bo__os
boot67759373bo__ot
boron76727143bo_ron
borrow114310723borrow
borzoi1736623borzoi
boshbok1844063boshbok
bosom95516923bo_som
boson76019733bo_son
boston8513043boston
bottom1048723bottom
boucle103712783boucle
boudin9412373boudin
boudoir1043853boudoir
bouffe14438313bouffe
bough115719313bou_gh
boughs125414373boughs
bought125115643bought
bougie93613273bougie
boule74828043bou_le
boules84925973boules
boulle84614613boulle
bounce104014833bounce
bouncy13409073bouncy
bound84819583bou_nd
bounds94415803bounds
bounty113411073bounty
bourbons1245343bourbons
bourdon1036423bourdon
bourg84113843bou_rg
bourgs9459993bourgs
bourn75518483bou_rn
bourne83714093bourne
bourns84114063bourns
bourse84414333bourse
bouse75931853bou_se
boused95322883boused
bouses84931783bouses
bousouki1451563bousouki
bousy104917843bou_sy
bout66353293bou__t
boutons9310783boutons
bouts75131313bou_ts
bouzouki2351203bouzouki
bowpot13410073bowpot
bowwow1334463bowwow
boyo96923843bo_yo_
boyos105418283bo_yos
bozo156821413bo_zo_
bozos165216863bo_zos
brulot8912213brulot
brumous11107443brumous
bub76343983b_ub__
bubal94218213b_ubal
bubba84311803b_ubba
bubby115013933b_ubby
buboed113010003b_uboed
buboes104513993b_uboes
bubs86235503b_ub_s
bubus95115453b_ubus
bugout9311863b_ugout
bulbous1138293bulbous
buoy95921783b_u_oy
burbot10815653burbot
busboy13307443busboy
buxom1647153b_uxom
buyout11310103b_uyout
combo114519433combo_
combos125316613combos
congou94313243congou
coupon102810993coupon
cowboy1637063cowboy
coypou13268403coypou
double94013993double
doubly12328963doubly
doubt8720093doub_t
doubts968733doubts
fogbow1544783fogbow
gobo76126903go_bo_
gobos86219383go_bos
gombo105814043gombo_
gombos114311093gombos
hobo97026083ho_bo_
hobos106321353ho_bos
hotbox1835703hotbox
kobo107422103ko_bo_
kobos115616893ko_bos
kombu1347243komb_u
kouroi1036513kouroi
kouros1039183kouros
lobo67229863lo_bo_
lobos75921843lo_bos
lowboy1435903lowboy
mouton8410853mouton
oboe66822943_o_boe
obol65220613_o_bol
outbox1537463_outbox
ouzo133516933_ouzo_
ouzos143210413_ouzos
oxbow1734443_oxbow
poboy121612223po_boy
potboy1397813potboy
poyou102611523po_you
robot7325973ro_bot
rouble83913313rouble
rubout8313563_rubout
soukous1136413soukous
tomboy1358213tomboy
vodou939343vo_dou
voudon1035873voudon
voudoun1143603voudoun
yobbo1237873yobbo_
yobbos1335963yobbos
youpon11366003youpon

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 Filter1786911127160.406440125.6
2DLD Change Limit1127161835.75019602.8
3Display Results1831830.0632904.8
 (SQL Overall)1786911836.21928733.1
 
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.