History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"offkey"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 152 | 2024-04-20 17:42:20 | offkey | 1 | 48755 | 1 | 1.983 | 24586.5 |
| 151 | 2024-04-11 11:58:20 | offkey | 1 | 48755 | 1 | 0.843 | 57835.1 |
| 150 | 2024-04-05 05:48:38 | offkey | 1 | 48755 | 1 | 2.190 | 22262.6 |
| 149 | 2024-03-31 11:11:08 | offkey | 1 | 48755 | 1 | 0.843 | 57835.1 |
| 148 | 2024-03-28 23:48:33 | offkey | 1 | 48755 | 1 | 0.940 | 51867.0 |
| 147 | 2024-02-26 15:59:19 | offkey | 1 | 48755 | 1 | 0.936 | 52088.7 |
| 146 | 2024-01-31 03:30:43 | offkey | 2 | 82551 | 5 | 2.216 | 37252.3 |
| 145 | 2024-01-31 03:30:35 | offkey | 3 | 112716 | 108 | 4.920 | 22909.8 |
| 144 | 2024-01-27 02:50:45 | offkey | 3 | 112716 | 108 | 5.266 | 21404.5 |
| 143 | 2024-01-27 02:19:19 | offkey | 2 | 82551 | 5 | 2.593 | 31836.1 |
| 142 | 2024-01-27 02:19:15 | offkey | 3 | 112716 | 108 | 5.796 | 19447.2 |
| 141 | 2024-01-27 02:19:11 | offkey | 1 | 48755 | 1 | 0.890 | 54780.9 |
| 140 | 2023-12-31 04:18:08 | offkey | 1 | 48755 | 1 | 0.783 | 62266.9 |
| 139 | 2023-12-26 09:37:30 | offkey | 1 | 48755 | 1 | 0.766 | 63648.8 |
| 138 | 2023-11-18 08:10:18 | offkey | 1 | 48755 | 1 | 0.733 | 66514.3 |
| 137 | 2023-10-14 23:02:10 | offkey | 1 | 48755 | 1 | 0.830 | 58741.0 |
| 136 | 2023-10-13 12:12:51 | offkey | 1 | 48755 | 1 | 0.750 | 65006.7 |
| 135 | 2023-10-09 18:51:53 | offkey | 1 | 48755 | 1 | 0.766 | 63648.8 |
| 134 | 2023-10-05 10:44:50 | offkey | 3 | 112716 | 108 | 5.013 | 22484.7 |
| 133 | 2023-10-01 18:55:22 | offkey | 3 | 112716 | 108 | 5.296 | 21283.2 |
| 132 | 2023-09-27 20:04:15 | offkey | 3 | 112716 | 108 | 4.953 | 22757.1 |
| 131 | 2023-09-27 20:04:16 | offkey | 2 | 82551 | 5 | 2.373 | 34787.6 |
| 130 | 2023-09-26 01:34:42 | offkey | 1 | 48755 | 1 | 0.720 | 67715.3 |
| 129 | 2023-09-17 04:50:35 | offkey | 1 | 48755 | 1 | 0.860 | 56691.9 |
| 128 | 2023-08-10 10:49:12 | offkey | 1 | 48755 | 1 | 0.720 | 67715.3 |
| 127 | 2023-07-24 06:44:29 | offkey | 1 | 48755 | 1 | 0.826 | 59025.4 |
| 126 | 2023-05-12 13:22:36 | offkey | 1 | 48755 | 1 | 0.720 | 67715.3 |
| 125 | 2023-04-24 01:46:51 | offkey | 1 | 48755 | 1 | 0.826 | 59025.4 |
| 124 | 2023-03-19 06:24:10 | offkey | 1 | 48755 | 1 | 0.733 | 66514.3 |
| 123 | 2023-03-06 15:53:50 | offkey | 1 | 48755 | 1 | 0.796 | 61250.0 |
| 122 | 2023-03-05 07:01:20 | offkey | 1 | 48755 | 1 | 0.736 | 66243.2 |
| 121 | 2023-03-01 20:01:54 | offkey | 1 | 48755 | 1 | 0.796 | 61250.0 |
| 120 | 2022-12-28 19:21:35 | offkey | 1 | 48755 | 1 | 0.733 | 66514.3 |
| 119 | 2022-10-04 12:14:25 | offkey | 1 | 48755 | 1 | 0.733 | 66514.3 |
| 118 | 2022-05-03 13:47:43 | offkey | 1 | 48755 | 1 | 0.826 | 59025.4 |
| 117 | 2021-12-21 12:39:24 | offkey | 1 | 48755 | 1 | 0.906 | 53813.5 |
| 116 | 2021-08-15 16:27:54 | offkey | 1 | 48755 | 1 | 0.720 | 67715.3 |
| 115 | 2021-04-20 06:22:53 | offkey | 1 | 48755 | 1 | 0.750 | 65006.7 |
| 114 | 2021-01-06 20:47:10 | offkey | 1 | 48755 | 1 | 1.076 | 45311.3 |
| 113 | 2020-11-11 13:24:37 | offkey | 1 | 48755 | 1 | 0.843 | 57835.1 |
| 112 | 2020-10-05 12:17:43 | offkey | 1 | 48755 | 1 | 0.813 | 59969.2 |
| 111 | 2020-06-05 22:31:09 | offkey | 1 | 48755 | 1 | 0.750 | 65006.7 |
| 110 | 2020-06-03 00:43:48 | offkey | 1 | 48755 | 1 | 0.813 | 59969.2 |
| 109 | 2020-03-29 03:12:34 | offkey | 1 | 48755 | 1 | 0.843 | 57835.1 |
| 108 | 2020-03-28 21:37:16 | offkey | 1 | 48755 | 1 | 0.860 | 56691.9 |
| 107 | 2020-03-23 01:20:04 | offkey | 1 | 48755 | 1 | 0.826 | 59025.4 |
| 106 | 2020-02-28 15:27:04 | offkey | 1 | 48755 | 1 | 0.826 | 59025.4 |
| 105 | 2020-02-01 00:26:33 | offkey | 1 | 48755 | 1 | 0.736 | 66243.2 |
| 104 | 2020-01-31 13:55:11 | offkey | 1 | 48755 | 1 | 0.936 | 52088.7 |
| 103 | 2020-01-31 09:21:06 | offkey | 1 | 48755 | 1 | 2.750 | 17729.1 |
| 102 | 2020-01-27 15:06:41 | offkey | 1 | 48755 | 1 | 1.173 | 41564.4 |
| 101 | 2020-01-27 04:28:43 | offkey | 1 | 48755 | 1 | 0.940 | 51867.0 |
| 100 | 2020-01-18 18:15:35 | offkey | 1 | 48755 | 1 | 0.860 | 56691.9 |
| 99 | 2020-01-15 04:49:20 | offkey | 1 | 48755 | 1 | 0.860 | 56691.9 |
| 98 | 2020-01-01 23:04:21 | offkey | 1 | 48755 | 1 | 1.813 | 26891.9 |
| 97 | 2019-12-30 07:56:53 | offkey | 1 | 48755 | 1 | 0.860 | 56691.9 |
| 96 | 2019-10-27 19:34:24 | offkey | 1 | 48755 | 1 | 0.856 | 56956.8 |
| 95 | 2019-07-14 00:24:26 | offkey | 1 | 48755 | 1 | 0.793 | 61481.7 |
| 94 | 2019-06-04 03:12:37 | offkey | 1 | 48755 | 1 | 0.763 | 63899.1 |
| 93 | 2019-05-29 18:44:52 | offkey | 1 | 48755 | 1 | 0.863 | 56494.8 |
| 92 | 2019-03-11 17:55:40 | offkey | 1 | 48755 | 1 | 0.873 | 55847.7 |
| 91 | 2019-03-05 12:30:41 | offkey | 1 | 48755 | 1 | 0.723 | 67434.3 |
| 90 | 2019-01-09 21:09:33 | offkey | 1 | 48755 | 1 | 0.723 | 67434.3 |
| 89 | 2018-12-23 11:06:27 | offkey | 1 | 48755 | 1 | 0.703 | 69352.8 |
| 88 | 2018-12-17 15:58:25 | offkey | 1 | 48755 | 1 | 0.710 | 68669.0 |
| 87 | 2018-11-10 10:19:56 | offkey | 1 | 48755 | 1 | 0.813 | 59969.2 |
| 86 | 2018-11-07 21:08:50 | offkey | 1 | 48755 | 1 | 0.700 | 69650.0 |
| 85 | 2018-11-03 22:54:36 | offkey | 1 | 48755 | 1 | 0.686 | 71071.4 |
| 84 | 2018-10-30 23:14:44 | offkey | 1 | 48755 | 1 | 0.716 | 68093.6 |
| 83 | 2018-10-02 06:31:10 | offkey | 1 | 48755 | 1 | 0.856 | 56956.8 |
| 82 | 2018-10-01 19:29:38 | offkey | 1 | 48755 | 1 | 0.746 | 65355.2 |
| 81 | 2018-09-24 17:24:48 | offkey | 1 | 48755 | 1 | 0.963 | 50628.2 |
| 80 | 2018-07-28 11:36:23 | offkey | 1 | 48755 | 1 | 0.836 | 58319.4 |
| 79 | 2018-07-11 08:18:23 | offkey | 1 | 48755 | 1 | 0.746 | 65355.2 |
| 78 | 2018-05-11 11:30:26 | offkey | 1 | 48755 | 1 | 0.803 | 60716.1 |
| 77 | 2018-05-10 02:39:22 | offkey | 1 | 48755 | 1 | 0.740 | 65885.1 |
| 76 | 2018-04-05 23:34:19 | offkey | 1 | 48755 | 1 | 1.023 | 47658.8 |
| 75 | 2018-04-05 23:34:06 | offkey | 1 | 48755 | 1 | 1.263 | 38602.5 |
| 74 | 2018-01-01 01:33:28 | offkey | 3 | 112716 | 108 | 8.790 | 12823.2 |
| 73 | 2017-12-16 22:21:24 | offkey | 1 | 48755 | 1 | 1.120 | 43531.3 |
| 72 | 2017-11-30 15:07:47 | offkey | 1 | 48755 | 1 | 1.536 | 31741.5 |
| 71 | 2017-10-31 11:46:25 | offkey | 1 | 48755 | 1 | 1.020 | 47799.0 |
| 70 | 2017-06-27 22:36:16 | offkey | 1 | 48755 | 1 | 0.963 | 50628.2 |
| 69 | 2017-05-03 10:10:38 | offkey | 1 | 48755 | 1 | 1.413 | 34504.6 |
| 68 | 2017-04-20 01:19:19 | offkey | 1 | 48755 | 1 | 0.940 | 51867.0 |
| 67 | 2017-02-10 06:35:55 | offkey | 1 | 48755 | 1 | 1.016 | 47987.2 |
| 66 | 2017-02-10 05:12:10 | offkey | 1 | 48755 | 1 | 1.013 | 48129.3 |
| 65 | 2017-01-03 16:59:37 | offkey | 1 | 48755 | 1 | 0.960 | 50786.5 |
| 64 | 2017-01-01 20:36:42 | offkey | 1 | 48755 | 1 | 2.333 | 20898.0 |
| 63 | 2016-12-05 12:43:33 | offkey | 1 | 48755 | 1 | 1.120 | 43531.3 |
| 62 | 2016-12-01 19:53:22 | offkey | 1 | 48755 | 1 | 1.030 | 47335.0 |
| 61 | 2016-11-25 00:11:20 | offkey | 1 | 48755 | 1 | 1.193 | 40867.6 |
| 60 | 2016-11-17 12:19:55 | offkey | 1 | 48755 | 1 | 1.230 | 39638.2 |
| 59 | 2016-11-15 16:20:52 | offkey | 1 | 48755 | 1 | 1.070 | 45565.4 |
| 58 | 2016-10-21 03:43:57 | offkey | 1 | 48755 | 1 | 1.026 | 47519.5 |
| 57 | 2016-10-19 08:11:23 | offkey | 1 | 48755 | 1 | 2.250 | 21668.9 |
| 56 | 2016-10-17 03:04:06 | offkey | 1 | 48755 | 1 | 1.153 | 42285.3 |
| 55 | 2016-10-14 15:44:50 | offkey | 1 | 48755 | 1 | 1.016 | 47987.2 |
| 54 | 2016-08-15 02:38:32 | offkey | 1 | 48755 | 1 | 1.133 | 43031.8 |
| 53 | 2016-08-06 09:13:39 | offkey | 1 | 48755 | 1 | 1.223 | 39865.1 |