History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"negotiated"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 159 | 2024-04-21 21:22:34 | negotiated | 2 | 108824 | 5 | 9.033 | 12047.4 |
| 158 | 2024-04-19 00:22:04 | negotiated | 2 | 108824 | 5 | 11.440 | 9512.6 |
| 157 | 2024-04-18 23:23:57 | negotiated | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 156 | 2024-04-13 20:34:16 | negotiated | 4 | 161450 | 157 | 16.826 | 9595.3 |
| 155 | 2024-04-13 08:29:57 | negotiated | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 154 | 2024-04-12 16:45:15 | negotiated | 4 | 161450 | 157 | 39.876 | 4048.8 |
| 153 | 2024-04-12 16:45:26 | negotiated | 3 | 140603 | 21 | 21.456 | 6553.1 |
| 152 | 2024-04-12 16:45:23 | negotiated | 2 | 108824 | 5 | 13.656 | 7969.0 |
| 151 | 2024-04-12 16:41:37 | negotiated | 1 | 67641 | 3 | 1.486 | 45518.8 |
| 150 | 2024-04-11 04:42:39 | negotiated | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 149 | 2024-03-28 02:46:36 | negotiated | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 148 | 2024-03-23 10:50:37 | negotiated | 3 | 140603 | 21 | 7.656 | 18365.1 |
| 147 | 2024-03-18 03:26:37 | negotiated | 3 | 140603 | 21 | 11.406 | 12327.1 |
| 146 | 2024-03-13 17:11:31 | negotiated | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 145 | 2024-03-13 14:33:25 | negotiated | 3 | 140603 | 21 | 9.830 | 14303.5 |
| 144 | 2024-03-11 14:48:09 | negotiated | 3 | 140603 | 21 | 20.796 | 6761.1 |
| 143 | 2024-03-11 14:48:05 | negotiated | 2 | 108824 | 5 | 3.660 | 29733.3 |
| 142 | 2024-03-11 14:44:37 | negotiated | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 141 | 2024-03-08 18:02:03 | negotiated | 3 | 140603 | 21 | 28.830 | 4877.0 |
| 140 | 2024-03-08 18:02:03 | negotiated | 2 | 108824 | 5 | 3.903 | 27882.1 |
| 139 | 2024-03-08 18:00:22 | negotiated | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 138 | 2024-03-07 02:09:19 | negotiated | 1 | 67641 | 3 | 1.436 | 47103.8 |
| 137 | 2024-03-06 12:50:15 | negotiated | 3 | 140603 | 21 | 16.406 | 8570.2 |
| 136 | 2024-03-06 12:50:15 | negotiated | 4 | 161450 | 157 | 14.753 | 10943.5 |
| 135 | 2024-03-06 12:50:13 | negotiated | 2 | 108824 | 5 | 3.733 | 29151.9 |
| 134 | 2024-03-06 12:46:08 | negotiated | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 133 | 2024-02-12 15:08:08 | negotiated | 1 | 67641 | 3 | 3.750 | 18037.6 |
| 132 | 2024-02-09 18:36:23 | negotiated | 1 | 67641 | 3 | 2.296 | 29460.4 |
| 131 | 2024-02-06 03:15:22 | negotiated | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 130 | 2024-01-30 11:47:35 | negotiated | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 129 | 2024-01-29 22:12:54 | negotiated | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 128 | 2024-01-29 20:59:47 | negotiated | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 127 | 2024-01-02 21:50:21 | negotiated | 1 | 67641 | 3 | 1.436 | 47103.8 |
| 126 | 2024-01-01 04:10:51 | negotiated | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 125 | 2023-12-07 11:40:15 | negotiated | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 124 | 2023-11-28 07:11:18 | negotiated | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 123 | 2023-09-20 17:23:57 | negotiated | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 122 | 2023-09-19 06:14:35 | negotiated | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 121 | 2023-09-15 22:00:20 | negotiated | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 120 | 2023-07-13 02:13:16 | negotiated | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 119 | 2023-05-09 08:00:57 | negotiated | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 118 | 2023-04-17 01:54:44 | negotiated | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 117 | 2023-02-09 01:11:34 | negotiated | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 116 | 2023-01-04 18:21:15 | negotiated | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 115 | 2022-08-17 08:34:37 | negotiated | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 114 | 2022-07-08 13:28:21 | negotiated | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 113 | 2022-07-06 08:22:02 | negotiated | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 112 | 2022-03-20 04:57:05 | negotiated | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 111 | 2022-03-16 18:26:56 | negotiated | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 110 | 2021-11-09 12:18:55 | negotiated | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 109 | 2021-07-20 07:02:36 | negotiated | 1 | 67641 | 3 | 1.060 | 63812.3 |
| 108 | 2021-05-18 06:11:17 | negotiated | 4 | 161450 | 157 | 10.736 | 15038.2 |
| 107 | 2021-04-18 07:01:08 | negotiated | 4 | 161450 | 157 | 11.736 | 13756.8 |
| 106 | 2021-04-17 12:51:24 | negotiated | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 105 | 2021-03-21 02:35:24 | negotiated | 4 | 161450 | 157 | 10.750 | 15018.6 |
| 104 | 2021-03-15 03:08:54 | negotiated | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 103 | 2021-02-23 18:15:28 | negotiated | 4 | 161450 | 157 | 10.906 | 14803.8 |
| 102 | 2021-02-18 07:35:45 | negotiated | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 101 | 2021-01-30 14:55:24 | negotiated | 4 | 161450 | 157 | 10.296 | 15680.8 |
| 100 | 2021-01-04 00:20:53 | negotiated | 1 | 67641 | 3 | 2.233 | 30291.5 |
| 99 | 2021-01-02 17:39:53 | negotiated | 4 | 161450 | 157 | 9.766 | 16531.8 |
| 98 | 2020-11-11 08:02:24 | negotiated | 4 | 161450 | 157 | 11.516 | 14019.6 |
| 97 | 2020-10-17 22:29:51 | negotiated | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 96 | 2020-10-02 08:07:56 | negotiated | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 95 | 2020-06-12 17:15:38 | negotiated | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 94 | 2020-03-26 11:55:53 | negotiated | 1 | 67641 | 3 | 2.330 | 29030.5 |
| 93 | 2020-03-24 18:49:31 | negotiated | 1 | 67641 | 3 | 1.953 | 34634.4 |
| 92 | 2020-03-05 18:46:57 | negotiated | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 91 | 2020-02-25 09:42:36 | negotiated | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 90 | 2020-02-14 19:19:51 | negotiated | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 89 | 2020-02-08 06:40:55 | negotiated | 1 | 67641 | 3 | 2.500 | 27056.4 |
| 88 | 2020-01-31 17:12:34 | negotiated | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 87 | 2020-01-30 13:43:03 | negotiated | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 86 | 2020-01-28 08:28:35 | negotiated | 1 | 67641 | 3 | 2.343 | 28869.4 |
| 85 | 2020-01-20 20:44:09 | negotiated | 1 | 67641 | 3 | 1.843 | 36701.6 |
| 84 | 2020-01-19 18:01:50 | negotiated | 3 | 140603 | 21 | 6.096 | 23064.8 |
| 83 | 2020-01-18 03:27:20 | negotiated | 3 | 140603 | 21 | 8.063 | 17438.1 |
| 82 | 2020-01-17 22:56:32 | negotiated | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 81 | 2020-01-04 05:36:39 | negotiated | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 80 | 2020-01-02 00:48:24 | negotiated | 1 | 67641 | 3 | 1.280 | 52844.5 |
| 79 | 2019-11-26 12:12:31 | negotiated | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 78 | 2019-10-05 13:12:34 | negotiated | 1 | 67641 | 3 | 0.953 | 70976.9 |
| 77 | 2019-08-27 20:08:03 | negotiated | 1 | 67641 | 3 | 0.980 | 69021.4 |
| 76 | 2019-07-24 18:36:25 | negotiated | 1 | 67641 | 3 | 1.113 | 60773.6 |
| 75 | 2019-05-18 19:14:05 | negotiated | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 74 | 2019-03-27 08:29:04 | negotiated | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 73 | 2019-01-24 14:02:15 | negotiated | 1 | 67641 | 3 | 1.360 | 49736.0 |
| 72 | 2018-10-18 01:38:04 | negotiated | 1 | 67641 | 3 | 1.050 | 64420.0 |
| 71 | 2018-09-27 15:09:22 | negotiated | 1 | 67641 | 3 | 1.226 | 55172.1 |
| 70 | 2018-08-18 14:41:30 | negotiated | 3 | 140603 | 21 | 5.580 | 25197.7 |
| 69 | 2018-08-18 14:38:51 | negotiated | 3 | 140603 | 21 | 6.210 | 22641.4 |
| 68 | 2018-08-18 14:23:25 | negotiated | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 67 | 2018-06-27 22:36:28 | negotiated | 1 | 67641 | 3 | 1.353 | 49993.3 |
| 66 | 2018-06-08 17:04:15 | negotiated | 1 | 67641 | 3 | 0.996 | 67912.7 |
| 65 | 2018-06-03 06:00:43 | negotiated | 1 | 67641 | 3 | 1.120 | 60393.8 |
| 64 | 2017-11-10 00:49:33 | negotiated | 1 | 67641 | 3 | 1.843 | 36701.6 |
| 63 | 2017-07-10 15:14:04 | negotiated | 1 | 67641 | 3 | 1.866 | 36249.2 |
| 62 | 2017-07-01 20:26:29 | negotiated | 3 | 140603 | 21 | 8.160 | 17230.8 |
| 61 | 2017-07-01 20:24:50 | negotiated | 1 | 67641 | 3 | 1.823 | 37104.2 |
| 60 | 2017-07-01 20:22:18 | negotiated | 1 | 67641 | 3 | 1.483 | 45610.9 |