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

161 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
boohoo114883(None) 
booboo1039461booboo
boocoo1039001boocoo
boohoos1237991boohoos
bookoo1248341bookoo
boho96923322b_oh_o
bohos105618252b_ohos
booboos1138142booboos
boocoos1137752boocoos
boohooed1444432boohooed
bookoos1337502bookoos
boyhood1646492boyhood
coocoo1069692coocoo
doodoo8108892doodoo
hoodoo10109982hoodoo
hoopoo1198752hoopoo
koodoo11107772koodoo
voodoo10127532voodoo
achoo10315083_achoo
ahchoo1445713ahchoo
baboo94319503b_aboo
bamboo12310013bamboo
barhop13319643barhop
bathos116215633bathos
bazoo163815673b_azoo
behoof1458683behoof
bhoot104322103bho_ot
bishop1336943bishop
blood85319523blo_od
bloom95918973blo_om
bloop96116153blo_op
blotto8198443blotto
boathook1744763boathook
boche124216953boch_e
boches134618523boches
boffo136010373b_offo
boffos14568193boffos
bogwood1446413bogwood
bohea105013733b_ohea
bolero8412093bolero
bollox1548743bollox
bolo65535953b_o_lo
bolos75531373b_olos
bolson8410683bolson
bonbon10310073bonbon
bongo85720943b_ongo
bongos95316653bongos
bonito8313433bonito
bonobo1037143bonobo
bonobos1136393bonobos
boo58163663b___oo
boob85932583b_o_ob
boobed114514873boobed
boobie104015293boobie
boobs96221993boo_bs
booby125319513boo_by
boodle93215033boodle
boody115420403boo_dy
booed85127273boo_ed
booger94816553booger
boogey124711523boogey
boogie93515993boogie
boogy114518323boo_gy
boohooing1563423boohooing
booing94521643booing
boojum1733843boojum
book106836333b_o_ok
booked135319503booked
booker124719193booker
bookie123516003bookie
books115729713boo_ks
bookshop1943423bookshop
boom87435673b_o_om
boombox2073613boombox
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
bosh96328973bosh__
boshbok1844063boshbok
boshes114721883boshes
bosom95516923b_osom
boson76019733b_oson
boston8513043boston
both96533433both__
bother115218063bother
bothy136713963both_y
bottom1048723bottom
boubou1038433boubou
bouton8311533bouton
bowpot13410073bowpot
bowshot1578253bowshot
bowwow1334463bowwow
boxwood2045243boxwood
boyhoods1744883boyhoods
boyo96923843b_o_yo
boyos105418283b_oyos
bozo156821413b_o_zo
bozos165216863b_ozos
bromo95217203bro_mo
bromos104213313bromos
bronco10179493bronco
broo65129823b__roo
brood84620243bro_od
brook114717763bro_ok
broom95022213bro_om
broos75126413bro_os
burgoo938933burgoo
cashoo11312253cashoo
coho97524493_coh_o
cohog117813043_cohog
cohos105921853_cohos
doodoos9107623doodoos
doowop1283853doowop
godhood1345143godhood
googol835843googol
holloo94415253holloo
hoodoos11109293hoodoos
hoopoe11911233hoopoe
hoopoos1298543hoopoos
kolhoz2264773kolhoz
koodoos12116393koodoos
nohow1137293_nohow
oho66534383__oh_o
ooh67637093_ooh__
oohed94214213_oohed
oohs75220693_ooh_s
pooh96027383pooh__
poohed123912523poohed
poohs103915713pooh_s
pothook1656883pothook
pothos114214693pothos
quohog1942503quohog
shoo75929893__shoo
sonhood1168313sonhood
voodoos1196343voodoos
wahoo112413083_wahoo
yahoo112911543_yahoo

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 Limit1127161614.75023729.7
3Display Results1611610.0463500.0
 (SQL Overall)1786911615.16934569.7
 
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.