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

204 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
booboo103946(None) 
booboos1138141booboos
boocoo1039001boocoo
boohoo1148831boohoo
bookoo1248341bookoo
baboo94319502b_aboo
bamboo12310012bamboo
bonbon10310072bonbon
bonobo1037142bonob_o
bonobos1136392bonobos
boob85932582boob__
boobed114514872boobed
boobie104015292boobie
boobs96221992boob_s
booby125319512boob_y
boocoos1137752boocoos
boohoos1237992boohoos
bookoos1337502bookoos
boombox2073612boombox
boubou1038432boubou
coocoo1069692coocoo
doodoo8108892doodoo
hoodoo10109982hoodoo
hoopoo1198752hoopoo
koodoo11107772koodoo
voodoo10127532voodoo
adobo84711593adob_o
adobos9438453adobos
babool103012153babool
baboon103613913baboon
baboos103517013baboos
balboa10389963balboa
bamboos1348753bamboos
baobab946403baobab
batboy1387533batboy
bazoo163815673b_azoo
bebop11410793b_ebop
bhoot104322103bho_ot
bilbo95513613bilb_o
bilboa10367843bilboa
bilbos105011203bilbos
bimbo114811873bimb_o
bimbos124610523bimbos
blob86027093blob__
blobs95620033blob_s
blood85319523blo_od
bloom95918973blo_om
bloop96116153blo_op
blotto8198443blotto
bob76755673b_ob__
bobbed104315833bobbed
bobber95016743bobber
bobbin93410733bobbin
bobble94115143bobble
bobby114814663b_obby
bobs86340653b_ob_s
boffo136010373b_offo
boffos14568193boffos
bogwood1446413bogwood
boho96923323b_o_ho
bohos105618253b_ohos
bolero8412093bolero
bollox1548743bollox
bolo65535953b_o_lo
bolos75531373b_olos
bolson8410683bolson
bomb106927423bomb__
bombax1935753bombax
bombe115519313bomb_e
bombed134113873bombed
bomber125014653bomber
bombes124916823bombes
bombs115818823bomb_s
bombyx2232693bombyx
bonbons1139333bonbons
bongo85720943b_ongo
bongos95316653bongos
bonito8313433bonito
boo58163663___boo
boobies113718203boobies
boobing123613913boobing
boobird1235233boobird
boobish14338943boobish
boodle93215033boodle
boody115420403boo_dy
booed85127273boo_ed
booger94816553booger
boogey124711523boogey
boogie93515993boogie
boogy114518323boo_gy
boohooed1444433boohooed
booing94521643booing
boojum1733843boojum
book106836333b_o_ok
booked135319503booked
booker124719193booker
bookie123516003bookie
books115729713boo_ks
boom87435673b_o_om
boomed115318133boomed
boomer104618513boomer
booms95427123boo_ms
boomy125421823boo_my
boon67142173b_o_on
boons75031913boo_ns
boor66130683b_o_or
boors74325013boo_rs
boos67955033b_o_os
boost75132473boo_st
boosts86115013boosts
boot67759373b_o_ot
booted94822733booted
bootee84323023bootee
booth105522013boo_th
booths115313793booths
bootie85421163bootie
boots75837973boo_ts
booty106125913boo_ty
booze164718913boo_ze
boozed184813833boozed
boozer174815963boozer
boozes174916523boozes
boozy194917063boo_zy
boron76727143b_oron
borrow114310723borrow
borzoi1736623borzoi
boshbok1844063boshbok
bosom95516923b_osom
boson76019733b_oson
boston8513043boston
bottom1048723bottom
boubous1138693boubous
bourbon1135813bourbon
bouton8311533bouton
bowpot13410073bowpot
bowwow1334463bowwow
boxwood2045243boxwood
boyhood1646493boyhood
boyo96923843b_o_yo
boyos105418283b_oyos
bozo156821413b_o_zo
bozos165216863b_ozos
bromo95217203bro_mo
bromos104213313bromos
bronco10179493bronco
broo65129823b__roo
brood84620243bro_od
brook114717763bro_ok
broom95022213bro_om
broos75126413bro_os
bubo85621913b_ub_o
bugaboo1244313bugaboo
burbot10815653burbot
burgoo938933burgoo
busboy13307443busboy
cocobolo1443683cocobolo
combo114519433comb_o
combos125316613combos
cookbook1544443cookbook
cowboy1637063cowboy
diobol936883diobol
dobro84412213_dobro
doobie94712683doobie
doodoos9107623doodoos
doowop1283853doowop
fogbow1544783fogbow
footboy1544913footboy
gobo76126903_gob_o
gobos86219383_gobos
gombo105814043gomb_o
gombos114311093gombos
goober93911743goober
googol835843googol
hobo97026083_hob_o
hobos106321353_hobos
holloo94415253holloo
hoodoos11109293hoodoos
hoopoe11911233hoopoe
hoopoos1298543hoopoos
hotbox1835703hotbox
kobo107422103_kob_o
kobos115616893_kobos
koodoos12116393koodoos
lobo67229863_lob_o
lobos75921843_lobos
logbook1454513logbook
looby108115623loob_y
lowboy1435903lowboy
moonbow1443873moonbow
nonbook1346283nonbook
oboe66822943__oboe
obol65220613__obol
oxbow1734443_oxbow
poboy121612223_poboy
potboy1397813potboy
robot7325973_robot
taboo73418093_taboo
tombolo1146103tombolo
tomboy1358213tomboy
toolbox1653633toolbox
voodoos1196343voodoos
woodbox2043693woodbox
yobbo1237873_yobbo
yobbos1335963yobbos

Search took 6 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.373479064.3
2DLD Change Limit1127162045.55020309.2
3Display Results2042040.0603400.0
 (SQL Overall)1786912045.98329866.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.