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 “bowwows” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
bowwows145412(None) 
bowwow1334461bowwow_
powwows1442851powwows
borrows12349252borrows
bowpots1446022bowpots
bowwowed1642172bowwowed
kowtows1742752kowtows
powwow1342832powwow_
barlows12259973barlows
barrows123411683barrows
bellows124313303bellows
belows114614183b_elows
besnows1245153besnows
bestows1248863bestows
billows123611283billows
blowdown1743243blowdown
blowdowns1842923blowdowns
blowjobs2241573blowjobs
blows105423833b__lows
boffos14568193boffo_s
bogwood1446413bogwood
bogwoods1544823bogwoods
bohos105618253bo_ho_s
bolos75531373bo_lo_s
bolsons969483bolsons
bonbons1139333bonbons
bongoes104314113bongoes
bongos95316653bongo_s
booboos1138143booboos
boobs96221993bo__obs
boocoos1137753boocoos
boohoos1237993boohoos
bookoos1337503bookoos
books115729713bo__oks
booms95427123bo__oms
boons75031913bo__ons
boors74325013bo__ors
boos67955033bo__o_s
boots75837973bo__ots
borons85520543bo_rons
borrow114310723borrow_
borzois1835833borzois
bosoms104913043bo_soms
bosons85016653bo_sons
bostons9312893bostons
bottoms1136983bottoms
boubous1138683boubous
boutons9310783boutons
bowels114315593bo_wels
bowers115523703bo_wers
bowfins15267703bowfins
bowings133612003bowings
bowknots1743063bowknots
bowlegs13366813bowlegs
bowlers123715783bowlers
bowless123310313bowless
bowls106121433bo_w_ls
bowpot13410073bowpo_t
bows96242863b___ows
bowses115718863bo_wses
bowshots1645093bowshots
bowwowing1742133bowwowing
bowyers15438733bowyers
boxwood2045243boxwood
boxwoods2144183boxwoods
boyos105418283bo_yo_s
bozos165216863bo_zo_s
brows105425983b__rows
burrows12399093burrows
cowboys1735253cowboys
doowops1363943doowops
downbows1783693downbows
fogbows1643853fogbows
follows13409923follows
hollows134412333hollows
kotows13446513ko_tows
kowtow1643463kowtow_
lowboys1534213lowboys
lowbrows1643483lowbrows
lowdown1454483lowdown
lowdowns1543463lowdowns
morrows12318723morrows
oxbows1833713_oxbows
powwowed1641693powwowed
sorrows10278403sorrows
wows104633493___wows

Search took 8 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 Limit134027867.12618808.2
3Display Results86860.0302866.7
 (SQL Overall)178691867.31224438.0
 
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.