History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scrubbed"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
138 | 2024-04-08 15:25:23 | scrubbed | 2 | 121059 | 23 | 5.656 | 21403.6 |
137 | 2024-04-08 08:51:45 | scrubbed | 1 | 82945 | 2 | 4.953 | 16746.4 |
136 | 2024-04-06 09:13:09 | scrubbed | 2 | 121059 | 23 | 15.500 | 7810.3 |
135 | 2024-04-06 09:13:00 | scrubbed | 3 | 146162 | 136 | 22.643 | 6455.1 |
134 | 2024-04-05 13:34:03 | scrubbed | 2 | 121059 | 23 | 10.563 | 11460.7 |
133 | 2024-04-05 13:34:07 | scrubbed | 1 | 82945 | 2 | 4.016 | 20653.6 |
132 | 2024-04-04 06:50:00 | scrubbed | 3 | 146162 | 136 | 18.656 | 7834.6 |
131 | 2024-04-03 14:58:54 | scrubbed | 3 | 146162 | 136 | 14.126 | 10347.0 |
130 | 2024-04-03 14:58:20 | scrubbed | 1 | 82945 | 2 | 3.736 | 22201.6 |
129 | 2024-04-03 14:58:08 | scrubbed | 2 | 121059 | 23 | 8.406 | 14401.5 |
128 | 2024-04-03 14:58:07 | scrubbed | 3 | 146162 | 136 | 8.656 | 16885.6 |
127 | 2024-04-03 14:58:03 | scrubbed | 1 | 82945 | 2 | 1.533 | 54106.3 |
126 | 2024-03-06 23:11:42 | scrubbed | 2 | 121059 | 23 | 13.420 | 9020.8 |
125 | 2024-03-06 04:22:34 | scrubbed | 2 | 121059 | 23 | 13.080 | 9255.3 |
124 | 2024-03-05 17:31:48 | scrubbed | 1 | 82945 | 2 | 5.030 | 16490.1 |
123 | 2024-03-04 22:22:14 | scrubbed | 2 | 121059 | 23 | 13.610 | 8894.9 |
122 | 2024-03-04 16:07:05 | scrubbed | 2 | 121059 | 23 | 3.203 | 37795.5 |
121 | 2024-03-04 12:11:42 | scrubbed | 1 | 82945 | 2 | 1.516 | 54713.1 |
120 | 2024-03-04 12:11:32 | scrubbed | 2 | 121059 | 23 | 5.733 | 21116.2 |
119 | 2024-03-04 12:11:01 | scrubbed | 1 | 82945 | 2 | 1.500 | 55296.7 |
118 | 2024-02-28 20:42:20 | scrubbed | 3 | 146162 | 136 | 7.843 | 18636.0 |
117 | 2024-02-27 06:29:30 | scrubbed | 3 | 146162 | 136 | 6.906 | 21164.5 |
116 | 2024-02-21 17:34:29 | scrubbed | 3 | 146162 | 136 | 11.406 | 12814.5 |
115 | 2024-02-15 08:57:30 | scrubbed | 3 | 146162 | 136 | 7.846 | 18628.9 |
114 | 2024-02-15 08:57:21 | scrubbed | 2 | 121059 | 23 | 3.796 | 31891.2 |
113 | 2024-02-08 12:13:12 | scrubbed | 2 | 121059 | 23 | 8.813 | 13736.4 |
112 | 2024-02-02 08:48:35 | scrubbed | 1 | 82945 | 2 | 1.313 | 63172.1 |
111 | 2024-02-02 04:48:48 | scrubbed | 2 | 121059 | 23 | 3.373 | 35890.6 |
110 | 2024-02-02 04:48:44 | scrubbed | 1 | 82945 | 2 | 1.376 | 60279.8 |
109 | 2024-01-29 06:38:05 | scrubbed | 3 | 146162 | 136 | 9.486 | 15408.2 |
108 | 2024-01-20 15:14:18 | scrubbed | 1 | 82945 | 2 | 1.530 | 54212.4 |
107 | 2024-01-16 05:12:07 | scrubbed | 3 | 146162 | 136 | 7.423 | 19690.4 |
106 | 2024-01-16 05:12:09 | scrubbed | 2 | 121059 | 23 | 3.983 | 30393.9 |
105 | 2024-01-03 01:08:49 | scrubbed | 1 | 82945 | 2 | 1.313 | 63172.1 |
104 | 2023-11-22 17:21:02 | scrubbed | 2 | 121059 | 23 | 3.216 | 37642.7 |
103 | 2023-11-18 06:08:30 | scrubbed | 1 | 82945 | 2 | 1.330 | 62364.7 |
102 | 2023-11-16 15:12:52 | scrubbed | 1 | 82945 | 2 | 1.263 | 65673.0 |
101 | 2023-11-05 20:38:03 | scrubbed | 1 | 82945 | 2 | 1.313 | 63172.1 |
100 | 2023-11-05 14:04:20 | scrubbed | 1 | 82945 | 2 | 1.360 | 60989.0 |
99 | 2023-10-29 11:15:45 | scrubbed | 1 | 82945 | 2 | 1.580 | 52496.8 |
98 | 2023-09-11 09:17:38 | scrubbed | 1 | 82945 | 2 | 1.376 | 60279.8 |
97 | 2023-09-04 21:06:29 | scrubbed | 1 | 82945 | 2 | 1.420 | 58412.0 |
96 | 2023-08-24 18:58:32 | scrubbed | 2 | 121059 | 23 | 3.283 | 36874.5 |
95 | 2023-06-11 12:12:42 | scrubbed | 1 | 82945 | 2 | 1.420 | 58412.0 |
94 | 2023-05-07 16:37:46 | scrubbed | 2 | 121059 | 23 | 3.123 | 38763.7 |
93 | 2023-03-31 03:45:01 | scrubbed | 1 | 82945 | 2 | 1.280 | 64800.8 |
92 | 2023-02-11 18:15:25 | scrubbed | 2 | 121059 | 23 | 3.203 | 37795.5 |
91 | 2023-01-13 12:19:25 | scrubbed | 1 | 82945 | 2 | 1.283 | 64649.3 |
90 | 2022-11-22 12:48:05 | scrubbed | 2 | 121059 | 23 | 3.343 | 36212.7 |
89 | 2022-11-04 20:22:54 | scrubbed | 1 | 82945 | 2 | 1.330 | 62364.7 |
88 | 2022-07-16 09:32:10 | scrubbed | 3 | 146162 | 136 | 7.733 | 18901.1 |
87 | 2022-06-26 04:32:10 | scrubbed | 2 | 121059 | 23 | 3.110 | 38925.7 |
86 | 2022-06-19 19:22:51 | scrubbed | 1 | 82945 | 2 | 1.296 | 64000.8 |
85 | 2021-04-27 10:06:58 | scrubbed | 1 | 82945 | 2 | 1.390 | 59672.7 |
84 | 2021-03-01 14:53:12 | scrubbed | 1 | 82945 | 2 | 1.420 | 58412.0 |
83 | 2020-11-17 07:40:18 | scrubbed | 1 | 82945 | 2 | 1.296 | 64000.8 |
82 | 2020-10-30 17:01:58 | scrubbed | 1 | 82945 | 2 | 1.313 | 63172.1 |
81 | 2020-10-27 03:14:38 | scrubbed | 1 | 82945 | 2 | 1.296 | 64000.8 |
80 | 2020-03-23 18:33:34 | scrubbed | 1 | 82945 | 2 | 1.280 | 64800.8 |
79 | 2020-03-13 11:50:13 | scrubbed | 1 | 82945 | 2 | 1.796 | 46183.2 |
78 | 2020-02-29 17:38:57 | scrubbed | 1 | 82945 | 2 | 1.530 | 54212.4 |
77 | 2020-02-08 05:00:34 | scrubbed | 1 | 82945 | 2 | 1.436 | 57761.1 |
76 | 2020-02-08 04:38:04 | scrubbed | 1 | 82945 | 2 | 2.283 | 36331.6 |
75 | 2020-02-04 17:39:08 | scrubbed | 1 | 82945 | 2 | 1.610 | 51518.6 |
74 | 2020-02-01 07:12:16 | scrubbed | 1 | 82945 | 2 | 4.703 | 17636.6 |
73 | 2020-01-28 21:21:56 | scrubbed | 1 | 82945 | 2 | 1.640 | 50576.2 |
72 | 2020-01-21 11:15:48 | scrubbed | 1 | 82945 | 2 | 1.500 | 55296.7 |
71 | 2020-01-11 17:46:48 | scrubbed | 1 | 82945 | 2 | 3.080 | 26930.2 |
70 | 2020-01-07 06:02:30 | scrubbed | 1 | 82945 | 2 | 1.593 | 52068.4 |
69 | 2020-01-04 20:54:02 | scrubbed | 1 | 82945 | 2 | 1.516 | 54713.1 |
68 | 2020-01-02 02:58:01 | scrubbed | 1 | 82945 | 2 | 3.186 | 26034.2 |
67 | 2019-12-01 22:01:31 | scrubbed | 1 | 82945 | 2 | 1.500 | 55296.7 |
66 | 2019-08-30 11:59:12 | scrubbed | 1 | 82945 | 2 | 1.313 | 63172.1 |
65 | 2019-05-21 12:04:17 | scrubbed | 1 | 82945 | 2 | 1.366 | 60721.1 |
64 | 2019-04-03 04:27:02 | scrubbed | 1 | 82945 | 2 | 1.460 | 56811.6 |
63 | 2019-01-27 08:04:55 | scrubbed | 1 | 82945 | 2 | 1.266 | 65517.4 |
62 | 2018-11-26 19:22:30 | scrubbed | 1 | 82945 | 2 | 1.260 | 65829.4 |
61 | 2018-10-03 02:44:13 | scrubbed | 1 | 82945 | 2 | 1.293 | 64149.3 |
60 | 2018-09-14 04:26:33 | scrubbed | 1 | 82945 | 2 | 1.290 | 64298.4 |
59 | 2018-08-15 18:32:14 | scrubbed | 1 | 82945 | 2 | 1.376 | 60279.8 |
58 | 2018-07-04 04:24:36 | scrubbed | 3 | 146162 | 136 | 7.146 | 20453.7 |
57 | 2018-07-04 04:22:34 | scrubbed | 1 | 82945 | 2 | 1.280 | 64800.8 |
56 | 2018-07-03 19:48:44 | scrubbed | 1 | 82945 | 2 | 1.416 | 58577.0 |
55 | 2018-06-23 05:38:11 | scrubbed | 1 | 82945 | 2 | 1.233 | 67270.9 |
54 | 2018-05-20 00:56:41 | scrubbed | 1 | 82945 | 2 | 1.393 | 59544.1 |
53 | 2018-05-19 03:50:06 | scrubbed | 1 | 82945 | 2 | 1.350 | 61440.7 |
52 | 2018-05-12 14:20:08 | scrubbed | 1 | 82945 | 2 | 1.320 | 62837.1 |
51 | 2017-06-12 07:16:15 | scrubbed | 1 | 82945 | 2 | 1.706 | 48619.6 |
50 | 2016-12-26 17:42:45 | scrubbed | 1 | 82945 | 2 | 3.853 | 21527.4 |
49 | 2016-12-07 14:15:41 | scrubbed | 1 | 82945 | 2 | 1.943 | 42689.1 |
48 | 2016-09-11 05:48:31 | scrubbed | 1 | 82945 | 2 | 1.856 | 44690.2 |
47 | 2016-09-05 21:22:11 | scrubbed | 1 | 82945 | 2 | 2.153 | 38525.3 |
46 | 2016-08-30 16:03:27 | scrubbed | 1 | 82945 | 2 | 1.526 | 54354.5 |
45 | 2016-08-30 13:39:38 | scrubbed | 1 | 82945 | 2 | 2.163 | 38347.2 |
44 | 2016-08-07 07:41:25 | scrubbed | 1 | 82945 | 2 | 1.843 | 45005.4 |
43 | 2016-07-06 08:00:23 | scrubbed | 2 | 121059 | 23 | 11.656 | 10386.0 |
42 | 2016-06-18 08:37:36 | scrubbed | 3 | 146162 | 136 | 12.513 | 11680.8 |
41 | 2016-06-13 18:21:21 | scrubbed | 1 | 82945 | 2 | 2.793 | 29697.5 |
40 | 2016-06-06 16:56:27 | scrubbed | 1 | 82945 | 2 | 2.463 | 33676.4 |
39 | 2016-04-26 09:48:12 | scrubbed | 1 | 82945 | 2 | 1.483 | 55930.5 |