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

61 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
burrowers148349(None) 
borrowers1474021borrowers
burrower1374261burrower_
furrowers1563501furrowers
borrower1384832borrower_
burrers93814492burr__ers
burrowed1444442burrowe_d
burrows12399092burrow__s
furrower1464032furrower_
harrowers1555682harrowers
sorrowers1274752sorrowers
airpowers1443473airpowers
barraters1138043barraters
barriers104311883barr_iers
barrows123411683barrow__s
beflowers17165823beflowers
bellowers14177623bellowers
bestowers14135323bestowers
blowers124313593b__lowers
borrowed1465043borrowe_d
borrows12349253borrow__s
bowers115523703b___owers
brewers123811053b__rewers
brokers133111913b__rokers
brooders112610243b_rooders
browsers13449203b__rowsers
burblers12399263bu_rblers
burdeners1245063burdeners
burgers103918573bu_r_gers
burghers1435633bu_rghers
burgonets1243513burgonets
buriers94017193bu_r_iers
burkers133716623bu_r_kers
burlers94120273bu_r_lers
burners94115673bu_r_ners
burrer83718473burr__er_
burrier93613553burr_ier_
burros85114993burro___s
burrow114610803burrow___
burrowing1544473burrowing
bursters1038983bu_rsters
buttoners1145703buttoners
crowers124614893__crowers
curriers103410753curr_iers
furriers11369493furr_iers
furriners12316323furriners
furrowed1563833furrowe_d
furrows13327793furrow__s
garroters1055813garroters
growers113612723__growers
harrower1446363harrower_
hurriers11358893hurr_iers
narrower1145063narrower_
outpowers1445193outpowers
outtowers1244763outtowers
parroters1156763parroters
rowers94924573___rowers
sorrower1165033sorrower_
throwers14106033_throwers
turnovers1243283turnovers
warpowers1744553warpowers

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 Filter1786911486410.1701051123.5
2DLD Change Limit148641617.73619214.2
3Display Results61610.0163812.5
 (SQL Overall)178691617.92222556.3
 
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.