History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"influenza"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 169 | 2024-05-02 22:43:59 | influenza | 1 | 81242 | 3 | 1.560 | 52078.2 |
| 168 | 2024-04-22 10:28:07 | influenza | 4 | 165329 | 40 | 28.796 | 5741.4 |
| 167 | 2024-04-18 08:39:10 | influenza | 4 | 165329 | 40 | 35.703 | 4630.7 |
| 166 | 2024-04-18 08:39:01 | influenza | 4 | 165329 | 40 | 36.410 | 4540.8 |
| 165 | 2024-04-18 08:39:01 | influenza | 3 | 148641 | 10 | 15.690 | 9473.6 |
| 164 | 2024-04-18 01:01:44 | influenza | 4 | 165329 | 40 | 44.423 | 3721.7 |
| 163 | 2024-04-17 23:52:10 | influenza | 5 | 174418 | 315 | 83.130 | 2098.1 |
| 162 | 2024-04-17 23:52:10 | influenza | 4 | 165329 | 40 | 45.816 | 3608.5 |
| 161 | 2024-04-17 23:52:07 | influenza | 3 | 148641 | 10 | 12.203 | 12180.7 |
| 160 | 2024-04-17 23:52:05 | influenza | 2 | 121436 | 6 | 10.283 | 11809.4 |
| 159 | 2024-04-17 23:51:45 | influenza | 1 | 81242 | 3 | 3.940 | 20619.8 |
| 158 | 2024-04-17 20:54:10 | influenza | 5 | 174418 | 315 | 65.253 | 2672.9 |
| 157 | 2024-04-17 14:19:39 | influenza | 5 | 174418 | 315 | 63.270 | 2756.7 |
| 156 | 2024-04-17 14:19:39 | influenza | 4 | 165329 | 40 | 27.376 | 6039.2 |
| 155 | 2024-04-17 14:19:42 | influenza | 3 | 148641 | 10 | 19.280 | 7709.6 |
| 154 | 2024-04-17 14:19:45 | influenza | 2 | 121436 | 6 | 15.440 | 7865.0 |
| 153 | 2024-04-17 13:39:06 | influenza | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 152 | 2024-04-07 12:21:29 | influenza | 1 | 81242 | 3 | 4.796 | 16939.5 |
| 151 | 2024-04-07 12:21:25 | influenza | 1 | 81242 | 3 | 3.860 | 21047.2 |
| 150 | 2024-03-16 23:10:10 | influenza | 5 | 174418 | 315 | 32.970 | 5290.2 |
| 149 | 2024-03-16 06:56:28 | influenza | 4 | 165329 | 40 | 29.283 | 5645.9 |
| 148 | 2024-03-14 18:39:21 | influenza | 5 | 174418 | 315 | 50.346 | 3464.4 |
| 147 | 2024-03-14 09:41:09 | influenza | 5 | 174418 | 315 | 25.690 | 6789.3 |
| 146 | 2024-03-14 09:41:08 | influenza | 4 | 165329 | 40 | 13.626 | 12133.3 |
| 145 | 2024-03-14 09:41:07 | influenza | 3 | 148641 | 10 | 7.140 | 20818.1 |
| 144 | 2024-03-14 09:41:09 | influenza | 2 | 121436 | 6 | 3.720 | 32644.1 |
| 143 | 2024-03-14 09:40:41 | influenza | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 142 | 2024-03-08 06:27:43 | influenza | 1 | 81242 | 3 | 3.200 | 25388.1 |
| 141 | 2024-03-08 03:39:43 | influenza | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 140 | 2024-03-06 13:47:49 | influenza | 1 | 81242 | 3 | 3.500 | 23212.0 |
| 139 | 2024-03-05 14:10:03 | influenza | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 138 | 2024-01-31 13:12:03 | influenza | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 137 | 2024-01-31 05:57:03 | influenza | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 136 | 2024-01-07 23:10:41 | influenza | 2 | 121436 | 6 | 3.310 | 36687.6 |
| 135 | 2024-01-04 01:37:39 | influenza | 1 | 81242 | 3 | 1.346 | 60358.1 |
| 134 | 2023-12-11 22:04:06 | influenza | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 133 | 2023-10-13 03:35:11 | influenza | 2 | 121436 | 6 | 3.063 | 39646.1 |
| 132 | 2023-09-27 22:00:08 | influenza | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 131 | 2023-09-09 14:44:49 | influenza | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 130 | 2023-07-25 09:22:14 | influenza | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 129 | 2023-07-23 18:01:24 | influenza | 2 | 121436 | 6 | 3.013 | 40304.0 |
| 128 | 2023-04-25 06:23:32 | influenza | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 127 | 2023-04-10 09:43:26 | influenza | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 126 | 2023-04-06 17:08:03 | influenza | 1 | 81242 | 3 | 1.170 | 69437.6 |
| 125 | 2023-04-04 08:53:15 | influenza | 2 | 121436 | 6 | 3.016 | 40263.9 |
| 124 | 2023-02-15 02:37:56 | influenza | 1 | 81242 | 3 | 1.393 | 58321.6 |
| 123 | 2022-12-29 06:59:36 | influenza | 2 | 121436 | 6 | 3.126 | 38847.1 |
| 122 | 2022-12-13 03:54:51 | influenza | 1 | 81242 | 3 | 2.280 | 35632.5 |
| 121 | 2022-11-03 22:46:35 | influenza | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 120 | 2022-08-31 04:00:09 | influenza | 2 | 121436 | 6 | 3.063 | 39646.1 |
| 119 | 2022-08-21 08:18:17 | influenza | 1 | 81242 | 3 | 1.190 | 68270.6 |
| 118 | 2022-06-08 03:54:50 | influenza | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 117 | 2022-04-09 12:53:26 | influenza | 1 | 81242 | 3 | 1.216 | 66810.9 |
| 116 | 2022-01-07 19:17:47 | influenza | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 115 | 2022-01-06 21:10:05 | influenza | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 114 | 2021-11-05 01:57:17 | influenza | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 113 | 2021-11-03 00:59:40 | influenza | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 112 | 2021-10-07 08:23:16 | influenza | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 111 | 2021-08-30 08:24:38 | influenza | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 110 | 2021-08-27 01:23:58 | influenza | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 109 | 2021-05-02 19:42:46 | influenza | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 108 | 2021-01-12 23:10:13 | influenza | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 107 | 2020-09-28 13:47:50 | influenza | 1 | 81242 | 3 | 1.623 | 50056.7 |
| 106 | 2020-05-22 23:31:56 | influenza | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 105 | 2020-04-20 06:07:53 | influenza | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 104 | 2020-03-27 21:16:29 | influenza | 5 | 174418 | 315 | 17.923 | 9731.5 |
| 103 | 2020-03-27 00:08:52 | influenza | 5 | 174418 | 315 | 17.203 | 10138.8 |
| 102 | 2020-02-29 05:35:04 | influenza | 5 | 174418 | 315 | 36.300 | 4804.9 |
| 101 | 2020-02-27 14:28:56 | influenza | 5 | 174418 | 315 | 19.546 | 8923.5 |
| 100 | 2020-02-25 15:42:17 | influenza | 1 | 81242 | 3 | 2.840 | 28606.3 |
| 99 | 2020-02-20 15:50:35 | influenza | 5 | 174418 | 315 | 21.690 | 8041.4 |
| 98 | 2020-02-20 14:34:39 | influenza | 5 | 174418 | 315 | 24.096 | 7238.5 |
| 97 | 2020-02-20 09:50:30 | influenza | 5 | 174418 | 315 | 21.873 | 7974.1 |
| 96 | 2020-02-19 00:02:03 | influenza | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 95 | 2020-02-12 21:34:55 | influenza | 1 | 81242 | 3 | 1.703 | 47705.2 |
| 94 | 2020-01-24 06:55:30 | influenza | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 93 | 2020-01-23 22:42:20 | influenza | 3 | 148641 | 10 | 8.656 | 17172.0 |
| 92 | 2020-01-23 22:42:16 | influenza | 2 | 121436 | 6 | 10.796 | 11248.2 |
| 91 | 2020-01-23 19:35:40 | influenza | 4 | 165329 | 40 | 25.563 | 6467.5 |
| 90 | 2020-01-23 17:39:22 | influenza | 1 | 81242 | 3 | 3.373 | 24086.0 |
| 89 | 2020-01-18 23:49:47 | influenza | 4 | 165329 | 40 | 14.720 | 11231.6 |
| 88 | 2020-01-15 23:03:52 | influenza | 5 | 174418 | 315 | 57.050 | 3057.3 |
| 87 | 2020-01-15 20:54:30 | influenza | 5 | 174418 | 315 | 21.500 | 8112.5 |
| 86 | 2020-01-15 19:27:05 | influenza | 3 | 148641 | 10 | 6.830 | 21763.0 |
| 85 | 2020-01-15 19:27:04 | influenza | 2 | 121436 | 6 | 3.593 | 33797.9 |
| 84 | 2020-01-15 16:18:52 | influenza | 5 | 174418 | 315 | 17.846 | 9773.5 |
| 83 | 2020-01-15 16:18:47 | influenza | 4 | 165329 | 40 | 12.296 | 13445.8 |
| 82 | 2020-01-15 14:27:26 | influenza | 1 | 81242 | 3 | 1.626 | 49964.3 |
| 81 | 2020-01-07 01:46:31 | influenza | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 80 | 2019-10-22 15:36:35 | influenza | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 79 | 2019-06-19 03:18:34 | influenza | 1 | 81242 | 3 | 1.316 | 61734.0 |
| 78 | 2019-02-09 19:50:38 | influenza | 1 | 81242 | 3 | 1.363 | 59605.3 |
| 77 | 2018-09-19 04:15:05 | influenza | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 76 | 2018-06-09 20:16:51 | influenza | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 75 | 2017-11-08 12:46:00 | influenza | 1 | 81242 | 3 | 4.663 | 17422.7 |
| 74 | 2017-09-04 04:22:17 | influenza | 1 | 81242 | 3 | 1.633 | 49750.2 |
| 73 | 2017-09-01 17:04:22 | influenza | 1 | 81242 | 3 | 2.220 | 36595.5 |
| 72 | 2017-05-28 16:43:43 | influenza | 1 | 81242 | 3 | 1.566 | 51878.7 |
| 71 | 2017-03-17 17:24:47 | influenza | 1 | 81242 | 3 | 1.656 | 49059.2 |
| 70 | 2016-12-03 01:28:28 | influenza | 1 | 81242 | 3 | 1.703 | 47705.2 |