History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subtitled"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 155 | 2024-05-01 05:43:31 | subtitled | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 154 | 2024-04-30 13:21:02 | subtitled | 1 | 81242 | 3 | 1.530 | 53099.3 |
| 153 | 2024-04-28 21:53:45 | subtitled | 1 | 81242 | 3 | 1.796 | 45235.0 |
| 152 | 2024-04-05 20:50:10 | subtitled | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 151 | 2024-03-30 14:07:18 | subtitled | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 150 | 2024-03-19 23:23:57 | subtitled | 1 | 81242 | 3 | 1.513 | 53696.0 |
| 149 | 2024-03-06 17:02:04 | subtitled | 1 | 81242 | 3 | 1.560 | 52078.2 |
| 148 | 2024-02-28 12:26:03 | subtitled | 1 | 81242 | 3 | 3.016 | 26937.0 |
| 147 | 2024-02-02 06:06:23 | subtitled | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 146 | 2024-01-28 11:40:31 | subtitled | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 145 | 2024-01-26 08:18:39 | subtitled | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 144 | 2024-01-20 14:53:26 | subtitled | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 143 | 2024-01-07 19:07:14 | subtitled | 1 | 81242 | 3 | 1.330 | 61084.2 |
| 142 | 2023-12-28 17:25:31 | subtitled | 4 | 165329 | 451 | 11.830 | 13975.4 |
| 141 | 2023-12-28 17:25:30 | subtitled | 3 | 148641 | 56 | 7.080 | 20994.5 |
| 140 | 2023-12-28 17:25:32 | subtitled | 2 | 121436 | 10 | 3.703 | 32794.0 |
| 139 | 2023-11-26 13:22:57 | subtitled | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 138 | 2023-10-30 11:22:49 | subtitled | 1 | 81242 | 3 | 1.596 | 50903.5 |
| 137 | 2023-10-30 10:25:06 | subtitled | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 136 | 2023-08-27 13:42:08 | subtitled | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 135 | 2023-08-23 14:39:36 | subtitled | 1 | 81242 | 3 | 1.330 | 61084.2 |
| 134 | 2023-05-25 12:47:56 | subtitled | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 133 | 2023-04-10 23:14:13 | subtitled | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 132 | 2023-03-20 09:44:05 | subtitled | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 131 | 2023-01-07 10:39:40 | subtitled | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 130 | 2022-11-25 14:40:42 | subtitled | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 129 | 2022-11-22 04:37:39 | subtitled | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 128 | 2022-10-01 03:51:56 | subtitled | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 127 | 2022-07-01 04:48:38 | subtitled | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 126 | 2022-05-16 21:57:02 | subtitled | 1 | 81242 | 3 | 1.330 | 61084.2 |
| 125 | 2022-04-25 01:02:43 | subtitled | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 124 | 2022-04-22 17:58:21 | subtitled | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 123 | 2022-02-08 00:07:48 | subtitled | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 122 | 2022-01-29 08:24:36 | subtitled | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 121 | 2022-01-27 03:46:29 | subtitled | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 120 | 2021-10-05 07:45:31 | subtitled | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 119 | 2021-10-02 04:21:19 | subtitled | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 118 | 2021-06-29 17:40:31 | subtitled | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 117 | 2021-06-19 11:59:10 | subtitled | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 116 | 2021-04-11 04:34:27 | subtitled | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 115 | 2021-03-16 22:19:44 | subtitled | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 114 | 2021-01-25 10:09:43 | subtitled | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 113 | 2020-11-22 22:38:50 | subtitled | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 112 | 2020-11-02 06:24:41 | subtitled | 1 | 81242 | 3 | 1.626 | 49964.3 |
| 111 | 2020-08-06 07:18:47 | subtitled | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 110 | 2020-08-03 06:44:49 | subtitled | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 109 | 2020-06-21 11:35:25 | subtitled | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 108 | 2020-04-19 04:30:30 | subtitled | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 107 | 2020-03-29 00:05:21 | subtitled | 1 | 81242 | 3 | 2.343 | 34674.3 |
| 106 | 2020-03-24 12:37:18 | subtitled | 1 | 81242 | 3 | 1.576 | 51549.5 |
| 105 | 2020-03-03 05:00:30 | subtitled | 1 | 81242 | 3 | 1.563 | 51978.2 |
| 104 | 2020-02-22 18:10:47 | subtitled | 1 | 81242 | 3 | 1.610 | 50460.9 |
| 103 | 2020-02-19 15:19:20 | subtitled | 1 | 81242 | 3 | 1.626 | 49964.3 |
| 102 | 2020-02-13 02:34:29 | subtitled | 1 | 81242 | 3 | 2.360 | 34424.6 |
| 101 | 2020-02-05 04:14:00 | subtitled | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 100 | 2020-01-25 17:34:57 | subtitled | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 99 | 2020-01-25 04:50:39 | subtitled | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 98 | 2020-01-22 04:16:38 | subtitled | 1 | 81242 | 3 | 3.310 | 24544.4 |
| 97 | 2020-01-18 14:04:11 | subtitled | 1 | 81242 | 3 | 1.626 | 49964.3 |
| 96 | 2020-01-16 20:49:18 | subtitled | 1 | 81242 | 3 | 2.373 | 34236.0 |
| 95 | 2020-01-04 02:53:25 | subtitled | 1 | 81242 | 3 | 1.456 | 55798.1 |
| 94 | 2020-01-02 01:05:46 | subtitled | 1 | 81242 | 3 | 3.186 | 25499.7 |
| 93 | 2019-12-31 05:41:55 | subtitled | 1 | 81242 | 3 | 2.516 | 32290.1 |
| 92 | 2019-10-05 10:35:37 | subtitled | 1 | 81242 | 3 | 1.163 | 69855.5 |
| 91 | 2019-09-25 14:42:52 | subtitled | 1 | 81242 | 3 | 1.193 | 68098.9 |
| 90 | 2019-06-19 14:53:29 | subtitled | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 89 | 2019-04-18 22:44:53 | subtitled | 1 | 81242 | 3 | 1.246 | 65202.2 |
| 88 | 2019-03-01 03:05:11 | subtitled | 1 | 81242 | 3 | 1.380 | 58871.0 |
| 87 | 2018-12-18 18:14:55 | subtitled | 1 | 81242 | 3 | 1.310 | 62016.8 |
| 86 | 2018-11-03 02:58:14 | subtitled | 1 | 81242 | 3 | 1.410 | 57618.4 |
| 85 | 2018-07-24 01:38:47 | subtitled | 1 | 81242 | 3 | 1.240 | 65517.7 |
| 84 | 2018-04-17 12:15:45 | subtitled | 1 | 81242 | 3 | 1.396 | 58196.3 |
| 83 | 2017-11-01 21:44:03 | subtitled | 4 | 165329 | 451 | 22.163 | 7459.7 |
| 82 | 2017-10-31 00:36:15 | subtitled | 1 | 81242 | 3 | 1.753 | 46344.6 |
| 81 | 2017-10-29 02:59:28 | subtitled | 4 | 165329 | 451 | 30.936 | 5344.2 |
| 80 | 2017-10-24 03:47:17 | subtitled | 3 | 148641 | 56 | 8.726 | 17034.3 |
| 79 | 2017-10-24 01:33:52 | subtitled | 4 | 165329 | 451 | 16.303 | 10141.0 |
| 78 | 2017-10-13 06:39:05 | subtitled | 1 | 81242 | 3 | 1.880 | 43213.8 |
| 77 | 2017-08-16 12:48:48 | subtitled | 1 | 81242 | 3 | 1.976 | 41114.4 |
| 76 | 2017-07-02 11:22:24 | subtitled | 1 | 81242 | 3 | 1.756 | 46265.4 |
| 75 | 2017-06-09 12:36:07 | subtitled | 1 | 81242 | 3 | 1.996 | 40702.4 |
| 74 | 2017-04-08 23:22:36 | subtitled | 1 | 81242 | 3 | 1.936 | 41963.8 |
| 73 | 2017-01-01 16:37:11 | subtitled | 1 | 81242 | 3 | 1.876 | 43306.0 |
| 72 | 2016-12-18 06:08:36 | subtitled | 1 | 81242 | 3 | 1.670 | 48647.9 |
| 71 | 2016-12-02 20:45:02 | subtitled | 1 | 81242 | 3 | 2.093 | 38816.1 |
| 70 | 2016-12-01 08:34:59 | subtitled | 1 | 81242 | 3 | 1.976 | 41114.4 |
| 69 | 2016-11-27 08:10:50 | subtitled | 1 | 81242 | 3 | 2.196 | 36995.4 |
| 68 | 2016-09-04 14:02:22 | subtitled | 1 | 81242 | 3 | 1.496 | 54306.1 |
| 67 | 2016-05-02 23:59:45 | subtitled | 1 | 81242 | 3 | 1.493 | 54415.3 |
| 66 | 2016-04-25 01:53:08 | subtitled | 1 | 81242 | 3 | 2.236 | 36333.6 |
| 65 | 2016-04-17 02:45:20 | subtitled | 1 | 81242 | 3 | 1.486 | 54671.6 |
| 64 | 2016-04-14 11:48:25 | subtitled | 1 | 81242 | 3 | 4.286 | 18955.2 |
| 63 | 2016-04-11 08:26:55 | subtitled | 1 | 81242 | 3 | 4.430 | 18339.1 |
| 62 | 2016-04-08 12:15:10 | subtitled | 1 | 81242 | 3 | 4.136 | 19642.6 |
| 61 | 2016-03-19 02:16:34 | subtitled | 1 | 81242 | 3 | 1.473 | 55154.1 |
| 60 | 2016-01-06 21:47:25 | subtitled | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 59 | 2015-12-26 07:24:55 | subtitled | 4 | 165329 | 451 | 22.806 | 7249.4 |
| 58 | 2015-12-26 01:46:32 | subtitled | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 57 | 2015-12-22 18:35:26 | subtitled | 4 | 165329 | 451 | 12.980 | 12737.2 |
| 56 | 2015-12-22 07:27:38 | subtitled | 4 | 165329 | 451 | 13.670 | 12094.3 |