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

94 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
borrowed146504(None) 
borrower1384831borrower
burrowed1444441burrowed
sorrowed1264831sorrowed
arrowed1148112_arrowed
borrow114310722borrow__
borrowers1474022borrowers
borrows12349252borrow_s
bowwowed1642172bowwowed
browed125216392b__rowed
burrower1374262burrower
cornrowed1543622cornrowed
corroded12147512corroded
farrowed1545282farrowed
furrowed1563832furrowed
harrowed1556262harrowed
marrowed1445972marrowed
narrowed1235202narrowed
sorrower1165042sorrower
barraged1297683barraged
barred95725793barr__ed
barreled1137843barreled
barrow114512763barrow__
barrows123411683barrow_s
becrowd1555173becrow_d
becrowded1842923becrowded
bellowed14158603bellowed
berobed1238233b_erobed
berried103714043berr_ied
besnowed14124413besnowed
bestowed14156623bestowed
bestrowed1585173bestrowed
billowed14137063billowed
birred94713203birr__ed
blowed125016693b__lowed
boarded113910503boar_ded
bolloxed1834473bolloxed
boobed114514873bo__obed
booed85127273bo__o_ed
boohooed1444433boohooed
booked135319503bo__oked
boomed115318133bo__omed
booted94822733bo__oted
boozed184813833bo__ozed
borated104116363bo_rated
bordered1248933bordered
bored85034303bo_r__ed
borked135117293bo_r_ked
borrowing1544563borrowing
bosomed1238003bo_somed
bottomed1344673bottomed
bowed114533423b___owed
brewed125411873b__rewed
brooded113510933b_rooded
brooked143610033b_rooked
broomed124111053b_roomed
browned134710973b__rowned
browsed134511233b__rowsed
burred95820723burr__ed
burrow114610803burrow__
burrowers1483493burrowers
burrows12399093burrow_s
carromed1338563carromed
cordoned12229613cordoned
corraded12128293corraded
corrode101310573corrode_
corrodes111310333corrodes
crowed124717303__crowed
escrowed1434653escrowed
followed15146273followed
forboded15215353forboded
furrower1464033furrower
garroted1056783garroted
harrower1446363harrower
hollowed15157023hollowed
kotowed1533773ko_towed
kowtowed1941953kowtowed
lowbrowed1841733lowbrowed
mirrored1145773mirrored
morrow113510093morrow__
morrows12318723morrow_s
narrower1145063narrower
outrowed1239433outrowed
parroted1158843parroted
pogromed1444813pogromed
powwowed1641693powwowed
rowed94034323___rowed
sorrow9339443sorrow__
sorrowers1274763sorrowers
sorrows10278403sorrow_s
strowed115312143_strowed
trowed104714653__trowed
worried11308693worr_ied
worrited1235743worrited

Search took 9 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.423422437.4
2DLD Change Limit146162947.59319249.6
3Display Results94940.0303133.3
 (SQL Overall)178691948.04622208.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.