History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fantastico"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 140 | 2024-04-25 17:48:28 | fantastico | 1 | 67641 | 3 | 2.656 | 25467.2 |
| 139 | 2024-04-13 06:21:36 | fantastico | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 138 | 2024-04-04 21:29:15 | fantastico | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 137 | 2024-03-29 17:10:04 | fantastico | 3 | 140603 | 21 | 15.440 | 9106.4 |
| 136 | 2024-03-29 17:10:03 | fantastico | 2 | 108824 | 5 | 10.080 | 10796.0 |
| 135 | 2024-03-29 16:32:42 | fantastico | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 134 | 2024-03-27 23:22:37 | fantastico | 3 | 140603 | 21 | 15.453 | 9098.8 |
| 133 | 2024-03-27 23:22:36 | fantastico | 2 | 108824 | 5 | 10.390 | 10473.9 |
| 132 | 2024-03-27 23:05:23 | fantastico | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 131 | 2024-03-26 20:11:21 | fantastico | 3 | 140603 | 21 | 23.236 | 6051.1 |
| 130 | 2024-03-26 20:11:18 | fantastico | 2 | 108824 | 5 | 4.516 | 24097.4 |
| 129 | 2024-03-26 17:41:45 | fantastico | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 128 | 2024-03-25 06:27:06 | fantastico | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 127 | 2024-03-15 06:20:10 | fantastico | 5 | 173545 | 414 | 34.673 | 5005.2 |
| 126 | 2024-03-15 04:56:58 | fantastico | 5 | 173545 | 414 | 67.020 | 2589.5 |
| 125 | 2024-03-13 15:05:00 | fantastico | 5 | 173545 | 414 | 49.020 | 3540.3 |
| 124 | 2024-03-11 19:07:42 | fantastico | 5 | 173545 | 414 | 52.016 | 3336.4 |
| 123 | 2024-03-06 04:40:42 | fantastico | 4 | 161450 | 67 | 20.046 | 8054.0 |
| 122 | 2024-03-05 10:38:54 | fantastico | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 121 | 2024-03-04 17:30:51 | fantastico | 4 | 161450 | 67 | 37.846 | 4266.0 |
| 120 | 2024-02-25 12:20:33 | fantastico | 5 | 173545 | 414 | 49.816 | 3483.7 |
| 119 | 2024-02-25 12:20:32 | fantastico | 4 | 161450 | 67 | 17.516 | 9217.3 |
| 118 | 2024-02-25 12:20:30 | fantastico | 3 | 140603 | 21 | 19.626 | 7164.1 |
| 117 | 2024-02-25 12:20:31 | fantastico | 2 | 108824 | 5 | 3.970 | 27411.6 |
| 116 | 2024-02-15 18:34:47 | fantastico | 1 | 67641 | 3 | 1.313 | 51516.4 |
| 115 | 2024-02-13 14:01:49 | fantastico | 5 | 173545 | 414 | 48.783 | 3557.5 |
| 114 | 2024-02-12 10:43:23 | fantastico | 5 | 173545 | 414 | 38.800 | 4472.8 |
| 113 | 2024-02-11 10:44:04 | fantastico | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 112 | 2024-02-08 16:19:29 | fantastico | 5 | 173545 | 414 | 65.113 | 2665.3 |
| 111 | 2024-01-30 21:02:23 | fantastico | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 110 | 2024-01-29 18:35:55 | fantastico | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 109 | 2023-12-11 05:24:26 | fantastico | 5 | 173545 | 414 | 17.173 | 10105.7 |
| 108 | 2023-12-11 05:24:27 | fantastico | 4 | 161450 | 67 | 11.593 | 13926.5 |
| 107 | 2023-12-11 05:24:21 | fantastico | 3 | 140603 | 21 | 5.953 | 23618.8 |
| 106 | 2023-12-11 05:24:17 | fantastico | 2 | 108824 | 5 | 3.153 | 34514.4 |
| 105 | 2023-12-05 05:54:04 | fantastico | 1 | 67641 | 3 | 1.143 | 59178.5 |
| 104 | 2023-11-30 00:45:08 | fantastico | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 103 | 2023-11-30 00:30:13 | fantastico | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 102 | 2023-11-10 21:58:15 | fantastico | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 101 | 2023-09-14 12:13:48 | fantastico | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 100 | 2023-06-25 05:25:29 | fantastico | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 99 | 2023-04-06 07:39:04 | fantastico | 1 | 67641 | 3 | 1.143 | 59178.5 |
| 98 | 2023-01-19 13:26:38 | fantastico | 1 | 67641 | 3 | 0.970 | 69733.0 |
| 97 | 2022-11-14 04:43:54 | fantastico | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 96 | 2022-07-04 21:51:31 | fantastico | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 95 | 2022-03-11 20:16:22 | fantastico | 1 | 67641 | 3 | 0.986 | 68601.4 |
| 94 | 2021-12-20 02:29:56 | fantastico | 1 | 67641 | 3 | 2.186 | 30942.8 |
| 93 | 2021-12-18 00:26:33 | fantastico | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 92 | 2021-11-08 10:22:16 | fantastico | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 91 | 2021-08-12 16:51:56 | fantastico | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 90 | 2021-06-23 10:46:20 | fantastico | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 89 | 2021-04-04 06:40:56 | fantastico | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 88 | 2021-02-12 13:36:48 | fantastico | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 87 | 2020-10-10 09:27:49 | fantastico | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 86 | 2020-03-29 20:56:16 | fantastico | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 85 | 2020-03-24 05:36:48 | fantastico | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 84 | 2020-02-21 08:56:31 | fantastico | 1 | 67641 | 3 | 1.610 | 42013.0 |
| 83 | 2020-02-21 07:58:28 | fantastico | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 82 | 2020-02-21 02:32:51 | fantastico | 1 | 67641 | 3 | 2.016 | 33552.1 |
| 81 | 2020-02-12 00:51:21 | fantastico | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 80 | 2020-02-08 14:22:39 | fantastico | 1 | 67641 | 3 | 3.906 | 17317.2 |
| 79 | 2020-02-04 23:37:35 | fantastico | 1 | 67641 | 3 | 1.283 | 52721.0 |
| 78 | 2020-01-18 10:49:57 | fantastico | 1 | 67641 | 3 | 1.376 | 49157.7 |
| 77 | 2020-01-18 09:58:12 | fantastico | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 76 | 2020-01-11 01:36:10 | fantastico | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 75 | 2020-01-07 21:07:19 | fantastico | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 74 | 2019-12-15 22:22:18 | fantastico | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 73 | 2019-09-14 10:40:33 | fantastico | 1 | 67641 | 3 | 1.060 | 63812.3 |
| 72 | 2019-09-11 08:29:26 | fantastico | 1 | 67641 | 3 | 1.133 | 59700.8 |
| 71 | 2019-09-03 03:51:12 | fantastico | 1 | 67641 | 3 | 1.066 | 63453.1 |
| 70 | 2019-06-02 09:58:11 | fantastico | 1 | 67641 | 3 | 1.003 | 67438.7 |
| 69 | 2019-05-30 07:47:42 | fantastico | 1 | 67641 | 3 | 0.996 | 67912.7 |
| 68 | 2019-05-27 05:25:39 | fantastico | 1 | 67641 | 3 | 1.040 | 65039.4 |
| 67 | 2019-02-22 20:27:50 | fantastico | 1 | 67641 | 3 | 1.180 | 57322.9 |
| 66 | 2019-01-29 23:28:30 | fantastico | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 65 | 2018-09-25 04:12:48 | fantastico | 1 | 67641 | 3 | 0.993 | 68117.8 |
| 64 | 2018-09-17 21:37:09 | fantastico | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 63 | 2018-09-17 16:05:34 | fantastico | 1 | 67641 | 3 | 1.070 | 63215.9 |
| 62 | 2018-09-15 04:22:24 | fantastico | 1 | 67641 | 3 | 1.180 | 57322.9 |
| 61 | 2018-07-23 11:24:37 | fantastico | 1 | 67641 | 3 | 1.053 | 64236.5 |
| 60 | 2018-07-21 18:54:03 | fantastico | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 59 | 2018-07-19 18:50:02 | fantastico | 1 | 67641 | 3 | 1.150 | 58818.3 |
| 58 | 2018-06-29 01:56:06 | fantastico | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 57 | 2018-06-26 21:33:35 | fantastico | 1 | 67641 | 3 | 1.960 | 34510.7 |
| 56 | 2018-06-16 15:43:05 | fantastico | 1 | 67641 | 3 | 1.106 | 61158.2 |
| 55 | 2017-11-14 03:20:55 | fantastico | 1 | 67641 | 3 | 1.713 | 39486.9 |
| 54 | 2017-10-26 17:35:02 | fantastico | 1 | 67641 | 3 | 2.293 | 29498.9 |
| 53 | 2017-08-06 06:40:19 | fantastico | 5 | 173545 | 414 | 20.933 | 8290.5 |
| 52 | 2017-08-06 06:24:18 | fantastico | 1 | 67641 | 3 | 1.346 | 50253.3 |
| 51 | 2016-12-13 03:55:48 | fantastico | 1 | 67641 | 3 | 1.540 | 43922.7 |
| 50 | 2016-12-02 07:36:45 | fantastico | 1 | 67641 | 3 | 1.640 | 41244.5 |
| 49 | 2016-10-25 18:06:54 | fantastico | 1 | 67641 | 3 | 2.673 | 25305.3 |
| 48 | 2016-10-21 00:49:38 | fantastico | 1 | 67641 | 3 | 1.646 | 41094.2 |
| 47 | 2016-10-21 00:45:12 | fantastico | 1 | 67641 | 3 | 1.706 | 39648.9 |
| 46 | 2016-10-19 04:16:17 | fantastico | 1 | 67641 | 3 | 1.483 | 45610.9 |
| 45 | 2016-09-12 20:12:27 | fantastico | 1 | 67641 | 3 | 1.756 | 38519.9 |
| 44 | 2016-06-29 10:38:05 | fantastico | 1 | 67641 | 3 | 5.440 | 12434.0 |
| 43 | 2016-06-28 21:01:23 | fantastico | 1 | 67641 | 3 | 1.810 | 37370.7 |
| 42 | 2016-03-12 17:14:08 | fantastico | 1 | 67641 | 3 | 1.083 | 62457.1 |
| 41 | 2016-02-28 23:09:25 | fantastico | 1 | 67641 | 3 | 2.326 | 29080.4 |