History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pheasants"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 181 | 2024-04-27 15:07:33 | pheasants | 4 | 165329 | 286 | 12.690 | 13028.3 |
| 180 | 2024-04-27 12:05:56 | pheasants | 1 | 81242 | 3 | 4.753 | 17092.8 |
| 179 | 2024-04-23 15:19:48 | pheasants | 1 | 81242 | 3 | 1.670 | 48647.9 |
| 178 | 2024-04-22 13:31:53 | pheasants | 3 | 148641 | 28 | 17.983 | 8265.6 |
| 177 | 2024-04-22 13:31:59 | pheasants | 1 | 81242 | 3 | 2.690 | 30201.5 |
| 176 | 2024-04-22 13:31:37 | pheasants | 2 | 121436 | 5 | 7.813 | 15542.8 |
| 175 | 2024-04-21 09:15:18 | pheasants | 2 | 121436 | 5 | 8.550 | 14203.0 |
| 174 | 2024-04-21 09:14:44 | pheasants | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 173 | 2024-04-17 22:44:36 | pheasants | 4 | 165329 | 286 | 17.220 | 9601.0 |
| 172 | 2024-04-16 10:40:00 | pheasants | 4 | 165329 | 286 | 49.360 | 3349.5 |
| 171 | 2024-04-16 10:39:54 | pheasants | 3 | 148641 | 28 | 20.486 | 7255.7 |
| 170 | 2024-04-16 10:39:59 | pheasants | 2 | 121436 | 5 | 13.703 | 8862.0 |
| 169 | 2024-04-16 10:17:50 | pheasants | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 168 | 2024-04-04 08:35:38 | pheasants | 4 | 165329 | 286 | 47.360 | 3490.9 |
| 167 | 2024-04-04 05:59:27 | pheasants | 4 | 165329 | 286 | 30.296 | 5457.1 |
| 166 | 2024-04-04 05:59:24 | pheasants | 2 | 121436 | 5 | 10.890 | 11151.1 |
| 165 | 2024-04-04 05:59:23 | pheasants | 3 | 148641 | 28 | 10.190 | 14586.9 |
| 164 | 2024-04-04 05:59:15 | pheasants | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 163 | 2024-03-31 23:04:09 | pheasants | 1 | 81242 | 3 | 1.796 | 45235.0 |
| 162 | 2024-03-29 11:31:22 | pheasants | 1 | 81242 | 3 | 4.546 | 17871.1 |
| 161 | 2024-03-25 22:43:40 | pheasants | 4 | 165329 | 286 | 31.080 | 5319.5 |
| 160 | 2024-03-25 21:39:35 | pheasants | 4 | 165329 | 286 | 12.110 | 13652.3 |
| 159 | 2024-03-18 01:14:10 | pheasants | 4 | 165329 | 286 | 50.003 | 3306.4 |
| 158 | 2024-03-17 18:35:55 | pheasants | 4 | 165329 | 286 | 36.750 | 4498.7 |
| 157 | 2024-03-15 06:02:40 | pheasants | 2 | 121436 | 5 | 4.233 | 28687.9 |
| 156 | 2024-03-14 15:00:59 | pheasants | 2 | 121436 | 5 | 13.296 | 9133.3 |
| 155 | 2024-03-14 13:45:03 | pheasants | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 154 | 2024-03-02 02:05:52 | pheasants | 4 | 165329 | 286 | 14.016 | 11795.7 |
| 153 | 2024-03-02 02:05:51 | pheasants | 3 | 148641 | 28 | 8.406 | 17682.7 |
| 152 | 2024-03-02 02:05:51 | pheasants | 2 | 121436 | 5 | 7.860 | 15449.9 |
| 151 | 2024-03-02 02:05:47 | pheasants | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 150 | 2024-02-26 09:58:39 | pheasants | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 149 | 2024-02-02 16:25:27 | pheasants | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 148 | 2024-01-29 01:49:28 | pheasants | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 147 | 2024-01-27 11:48:47 | pheasants | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 146 | 2024-01-20 03:28:50 | pheasants | 1 | 81242 | 3 | 1.300 | 62493.8 |
| 145 | 2024-01-10 06:39:33 | pheasants | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 144 | 2023-11-30 00:29:15 | pheasants | 4 | 165329 | 286 | 12.533 | 13191.5 |
| 143 | 2023-11-23 21:09:41 | pheasants | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 142 | 2023-10-11 13:38:37 | pheasants | 1 | 81242 | 3 | 3.126 | 25989.1 |
| 141 | 2023-09-09 21:36:51 | pheasants | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 140 | 2023-08-29 21:52:04 | pheasants | 4 | 165329 | 286 | 10.656 | 15515.1 |
| 139 | 2023-06-18 18:08:22 | pheasants | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 138 | 2023-05-31 03:33:15 | pheasants | 4 | 165329 | 286 | 10.470 | 15790.7 |
| 137 | 2023-05-29 05:27:33 | pheasants | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 136 | 2023-05-14 13:32:23 | pheasants | 4 | 165329 | 286 | 10.826 | 15271.5 |
| 135 | 2023-04-11 10:43:57 | pheasants | 4 | 165329 | 286 | 10.456 | 15811.9 |
| 134 | 2023-04-10 21:34:36 | pheasants | 1 | 81242 | 3 | 1.216 | 66810.9 |
| 133 | 2023-04-02 15:28:27 | pheasants | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 132 | 2023-03-27 06:53:27 | pheasants | 4 | 165329 | 286 | 10.546 | 15676.9 |
| 131 | 2023-03-22 19:01:13 | pheasants | 4 | 165329 | 286 | 11.810 | 13999.1 |
| 130 | 2023-02-19 06:34:55 | pheasants | 4 | 165329 | 286 | 10.640 | 15538.4 |
| 129 | 2023-02-17 15:11:47 | pheasants | 4 | 165329 | 286 | 11.550 | 14314.2 |
| 128 | 2023-01-26 09:31:15 | pheasants | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 127 | 2023-01-24 11:31:21 | pheasants | 4 | 165329 | 286 | 10.440 | 15836.1 |
| 126 | 2023-01-17 05:54:02 | pheasants | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 125 | 2023-01-07 20:03:28 | pheasants | 4 | 165329 | 286 | 12.266 | 13478.6 |
| 124 | 2022-12-30 20:37:22 | pheasants | 4 | 165329 | 286 | 10.280 | 16082.6 |
| 123 | 2022-12-01 19:37:32 | pheasants | 4 | 165329 | 286 | 10.520 | 15715.7 |
| 122 | 2022-11-13 18:53:32 | pheasants | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 121 | 2022-09-13 06:04:57 | pheasants | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 120 | 2022-07-08 17:02:27 | pheasants | 4 | 165329 | 286 | 10.566 | 15647.3 |
| 119 | 2022-07-04 06:29:56 | pheasants | 1 | 81242 | 3 | 1.216 | 66810.9 |
| 118 | 2022-07-02 00:33:14 | pheasants | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 117 | 2022-04-16 04:47:06 | pheasants | 1 | 81242 | 3 | 2.470 | 32891.5 |
| 116 | 2021-12-08 23:55:36 | pheasants | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 115 | 2021-08-12 16:14:09 | pheasants | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 114 | 2021-04-27 23:27:03 | pheasants | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 113 | 2021-02-21 01:50:09 | pheasants | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 112 | 2021-01-23 08:14:19 | pheasants | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 111 | 2020-11-13 00:53:28 | pheasants | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 110 | 2020-11-02 07:06:54 | pheasants | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 109 | 2020-10-21 10:49:03 | pheasants | 1 | 81242 | 3 | 1.330 | 61084.2 |
| 108 | 2020-07-16 09:40:46 | pheasants | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 107 | 2020-04-08 11:10:27 | pheasants | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 106 | 2020-03-27 06:53:57 | pheasants | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 105 | 2020-03-23 14:59:09 | pheasants | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 104 | 2020-03-22 21:14:18 | pheasants | 1 | 81242 | 3 | 1.486 | 54671.6 |
| 103 | 2020-03-04 14:47:07 | pheasants | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 102 | 2020-02-21 09:33:39 | pheasants | 1 | 81242 | 3 | 2.983 | 27235.0 |
| 101 | 2020-02-08 02:33:04 | pheasants | 1 | 81242 | 3 | 2.170 | 37438.7 |
| 100 | 2020-02-04 09:47:19 | pheasants | 1 | 81242 | 3 | 1.533 | 52995.4 |
| 99 | 2020-01-29 03:32:35 | pheasants | 1 | 81242 | 3 | 4.500 | 18053.8 |
| 98 | 2020-01-26 22:48:15 | pheasants | 3 | 148641 | 28 | 12.940 | 11486.9 |
| 97 | 2020-01-26 22:29:08 | pheasants | 2 | 121436 | 5 | 3.736 | 32504.3 |
| 96 | 2020-01-26 17:21:05 | pheasants | 1 | 81242 | 3 | 1.593 | 50999.4 |
| 95 | 2020-01-24 21:08:20 | pheasants | 1 | 81242 | 3 | 1.580 | 51419.0 |
| 94 | 2020-01-18 08:41:29 | pheasants | 1 | 81242 | 3 | 1.513 | 53696.0 |
| 93 | 2020-01-14 08:47:58 | pheasants | 1 | 81242 | 3 | 1.580 | 51419.0 |
| 92 | 2020-01-02 02:48:19 | pheasants | 1 | 81242 | 3 | 2.780 | 29223.7 |
| 91 | 2019-12-31 08:09:36 | pheasants | 1 | 81242 | 3 | 1.733 | 46879.4 |
| 90 | 2019-12-27 21:22:14 | pheasants | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 89 | 2019-09-27 07:15:57 | pheasants | 1 | 81242 | 3 | 1.173 | 69260.0 |
| 88 | 2019-06-18 04:24:38 | pheasants | 1 | 81242 | 3 | 1.383 | 58743.3 |
| 87 | 2019-04-01 01:10:38 | pheasants | 1 | 81242 | 3 | 1.256 | 64683.1 |
| 86 | 2019-02-27 15:57:33 | pheasants | 1 | 81242 | 3 | 1.190 | 68270.6 |
| 85 | 2019-01-28 11:15:00 | pheasants | 1 | 81242 | 3 | 1.323 | 61407.4 |
| 84 | 2018-10-29 18:12:51 | pheasants | 1 | 81242 | 3 | 1.440 | 56418.1 |
| 83 | 2018-10-11 11:42:40 | pheasants | 1 | 81242 | 3 | 1.276 | 63669.3 |
| 82 | 2018-10-08 01:52:49 | pheasants | 1 | 81242 | 3 | 1.316 | 61734.0 |