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

101 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
bowwow133446(None) 
bowwows1454121bowwows
powwow1342831powwow
borrow114310732borrow
bowpot13410072bowpot
bowwowed1642172bowwowed
kowtow1643462kowtow
powwows1442852powwows
barlow112911433barlow
barrow114512773barrow
bellow114213353bellow
below104617193b_elow
besnow1145713besnow
bestow1149463bestow
billow114111223billow
blow95827193b__low
blowdown1743243blowdown
blowjob2141753blowjob
boffo136010373boffo_
boffos14568193boffos
bogwood1446413bogwood
boho96923323bo_ho_
bohos105618253bo_hos
bollox1548743bollox
bolo65535953bo_lo_
bolos75531373bo_los
bolson8410683bolson
bonbon10310073bonbon
bongo85720943bongo_
bongos95316653bongos
boo58163663bo__o_
boob85932583bo__ob
booboo1039463booboo
boocoo1039003boocoo
boohoo1148833boohoo
book106836333bo__ok
bookoo1248343bookoo
boom87435673bo__om
boon67142173bo__on
boor66130683bo__or
boos67955033bo__os
boot67759373bo__ot
boron76727143bo_ron
borrows12349263borrows
borzoi1736623borzoi
bosom95516923bo_som
boson76019733bo_son
boston8513043boston
bottom1048723bottom
boubou1038433boubou
bouton8311533bouton
bow87051903b___ow
bowed114533423bo_wed
bowel105621203bo_wel
bowels114315593bowels
bower107328183bo_wer
bowers115523703bowers
bowery146012113bowery
bowfin14338353bowfin
bowing124723063bowing
bowknot1645773bowknot
bowl96827703bo_w_l
bowled125018143bowled
bowleg12369183bowleg
bowler114217313bowler
bowls106121433bo_wls
bowman13129853bowman
bowmen1399853bowmen
bowpots1446023bowpots
bows96242863bo_w_s
bowse105420633bo_wse
bowsed125715973bowsed
bowses115718863bowses
bowshot1578253bowshot
bowwowing1742133bowwowing
bowyer14368923bowyer
boxwood2045243boxwood
boyo96923843bo_yo_
boyos105418283bo_yos
bozo156821413bo_zo_
bozos165216863bo_zos
brow97228443b__row
burrow114610813burrow
cowboy1637063cowboy
cowpox2035003cowpox
doowop1283853doowop
downbow1653393downbow
fogbow1544783fogbow
follow124010353follow
hollow124212663hollow
kotow12528713ko_tow
kowtows1742763kowtows
lowboy1435903lowboy
lowbrow1543273lowbrow
lowdown1454483lowdown
morrow113510093morrow
nohow1137293no_how
oxbow1734443_oxbow
powwowed1641693powwowed
sorrow9339443sorrow
wow96643473___wow

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.376475242.0
2DLD Change Limit1127161015.06322262.7
3Display Results1011010.0303366.7
 (SQL Overall)1786911015.46932673.4
 
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.