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

87 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
crowbars154444(None) 
crowbar1444271crowbar_
crossbars1344432crossbars
crowders14398812crowders
crowers124614902crow_ers
crowners133710752crowners
drawbars1483102drawbars
acrobats1258343acro_bats
browband1643883browband
browbands1743403browbands
browbeats1642893browbeats
browsers13449203browsers
chowders17387543chowders
clobbers14397513clobbers
clowders14357473clowders
cobbers134114753c_obbers
cobras104014193c_o_bras
collars93816573c_ollars
combats13311683c_ombats
combers134516623c_ombers
corbans11313173c_orbans
costars94218013c_ostars
cottars94412243c_ottars
cougars1038443c_ougars
coward12411673c_ow_ard
cowards1339613c_ow_ards
cowbane1437673c_owbane
cowbanes1537423c_owbanes
cowbird1534433c_owbird
cowbirds1644043c_owbirds
cowboys1735253c_owboys
cowers114625533c_ow_ers
cowpats1437713c_owpats
crabbers14358753crabbers
crawdads1542653crawdads
crawlers13309013crawlers
cribbers14306443cribbers
croakers14288523croakers
croaks125812983cro__aks
crofters13358903crofters
crooners103911393crooners
croppers143311483croppers
crosiers103312063crosiers
crossarm1245133crossarm
crossarms1343973crossarms
crossbar1254483crossbar_
crossers103912703crossers
crowbarred1851433crowbarred
crowberry1942373crowberry
crowder13389863crowder_
crowdies1437553crowdies
crowds124910763crow__ds
crower114117563crow_er_
crowner124012603crowner_
crownets13407673crownets
crowns115615113crow__ns
crows105727313crow___s
crozers184111083cro_zers
croziers19287003croziers
crumbers14338243crumbers
drawbar13103193drawbar_
drowners12428273drowners
froward1436673frow_ard
frowners14377933frowners
growers113612723grow_ers
growlers12327093growlers
ironbark1443063ironbark
ironbarks1542703ironbarks
isobars936593iso_bars
jowars16369653_jow_ars
microbars1546883micro_bars
probers113514583pro_bers
prowar114110943prow_ar_
prowlers13328933prowlers
rebars84019833_r_ebars
rewears102911043_rewears
roars55622243_ro__ars
robbers112814163_robbers
rowans95715343_row_ans
rowboats1384843_rowboats
rowers94924573_row_ers
sowars94318013_sow_ars
sowcars1236013_sowcars
toolbars1044743toolbars
trocars959043tro_cars
trochars1377853trochars
trowsers11428003trowsers

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 Filter1786911461620.403443402.0
2DLD Change Limit146162876.34623032.1
3Display Results87870.0302900.0
 (SQL Overall)178691876.77926359.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.