History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"plainsongs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
139 | 2024-05-01 03:26:29 | plainsongs | 4 | 161450 | 83 | 14.673 | 11003.2 |
138 | 2024-04-30 05:51:24 | plainsongs | 4 | 161450 | 83 | 16.190 | 9972.2 |
137 | 2024-04-18 03:01:59 | plainsongs | 4 | 161450 | 83 | 33.316 | 4846.0 |
136 | 2024-04-17 20:54:41 | plainsongs | 4 | 161450 | 83 | 32.160 | 5020.2 |
135 | 2024-04-17 05:58:01 | plainsongs | 4 | 161450 | 83 | 42.156 | 3829.8 |
134 | 2024-04-17 01:12:27 | plainsongs | 4 | 161450 | 83 | 33.470 | 4823.7 |
133 | 2024-04-17 00:22:59 | plainsongs | 4 | 161450 | 83 | 48.533 | 3326.6 |
132 | 2024-04-17 00:22:58 | plainsongs | 5 | 173545 | 813 | 45.766 | 3792.0 |
131 | 2024-04-17 00:23:00 | plainsongs | 2 | 108824 | 2 | 9.690 | 11230.5 |
130 | 2024-04-17 00:22:59 | plainsongs | 3 | 140603 | 9 | 10.063 | 13972.3 |
129 | 2024-04-17 00:06:22 | plainsongs | 1 | 67641 | 2 | 1.280 | 52844.5 |
128 | 2024-03-31 10:49:49 | plainsongs | 2 | 108824 | 2 | 6.080 | 17898.7 |
127 | 2024-03-31 10:49:42 | plainsongs | 3 | 140603 | 9 | 7.830 | 17957.0 |
126 | 2024-03-31 09:41:55 | plainsongs | 1 | 67641 | 2 | 2.343 | 28869.4 |
125 | 2024-03-23 09:18:06 | plainsongs | 4 | 161450 | 83 | 14.640 | 11028.0 |
124 | 2024-03-20 18:38:49 | plainsongs | 4 | 161450 | 83 | 38.406 | 4203.8 |
123 | 2024-03-19 18:20:06 | plainsongs | 4 | 161450 | 83 | 47.363 | 3408.8 |
122 | 2024-03-19 14:51:50 | plainsongs | 4 | 161450 | 83 | 36.970 | 4367.1 |
121 | 2024-03-18 01:39:53 | plainsongs | 5 | 173545 | 813 | 53.833 | 3223.8 |
120 | 2024-03-18 01:40:02 | plainsongs | 4 | 161450 | 83 | 41.813 | 3861.2 |
119 | 2024-03-18 01:40:11 | plainsongs | 2 | 108824 | 2 | 8.596 | 12659.8 |
118 | 2024-03-18 01:39:58 | plainsongs | 3 | 140603 | 9 | 16.423 | 8561.3 |
117 | 2024-03-18 01:33:17 | plainsongs | 1 | 67641 | 2 | 1.186 | 57032.9 |
116 | 2024-03-12 06:37:23 | plainsongs | 1 | 67641 | 2 | 1.110 | 60937.8 |
115 | 2024-03-08 21:40:55 | plainsongs | 1 | 67641 | 2 | 1.766 | 38301.8 |
114 | 2024-03-07 14:57:28 | plainsongs | 1 | 67641 | 2 | 1.063 | 63632.2 |
113 | 2024-02-05 13:48:51 | plainsongs | 1 | 67641 | 2 | 1.173 | 57665.0 |
112 | 2024-01-31 09:16:30 | plainsongs | 1 | 67641 | 2 | 1.766 | 38301.8 |
111 | 2024-01-28 12:27:43 | plainsongs | 1 | 67641 | 2 | 1.046 | 64666.3 |
110 | 2024-01-20 07:56:02 | plainsongs | 1 | 67641 | 2 | 1.076 | 62863.4 |
109 | 2023-12-29 06:49:54 | plainsongs | 5 | 173545 | 813 | 17.830 | 9733.3 |
108 | 2023-12-29 06:49:50 | plainsongs | 4 | 161450 | 83 | 11.500 | 14039.1 |
107 | 2023-12-29 06:49:48 | plainsongs | 3 | 140603 | 9 | 6.313 | 22272.0 |
106 | 2023-12-29 06:49:51 | plainsongs | 2 | 108824 | 2 | 3.126 | 34812.5 |
105 | 2023-12-16 19:23:59 | plainsongs | 1 | 67641 | 2 | 1.110 | 60937.8 |
104 | 2023-11-14 00:50:17 | plainsongs | 1 | 67641 | 2 | 1.656 | 40846.0 |
103 | 2023-09-15 03:11:02 | plainsongs | 1 | 67641 | 2 | 1.156 | 58513.0 |
102 | 2023-09-06 01:56:29 | plainsongs | 1 | 67641 | 2 | 1.140 | 59334.2 |
101 | 2023-08-19 01:59:52 | plainsongs | 1 | 67641 | 2 | 1.000 | 67641.0 |
100 | 2023-07-12 21:29:58 | plainsongs | 1 | 67641 | 2 | 1.093 | 61885.6 |
99 | 2023-04-10 08:45:22 | plainsongs | 1 | 67641 | 2 | 2.190 | 30886.3 |
98 | 2022-11-18 03:01:50 | plainsongs | 1 | 67641 | 2 | 1.046 | 64666.3 |
97 | 2022-06-15 08:58:04 | plainsongs | 1 | 67641 | 2 | 1.000 | 67641.0 |
96 | 2022-01-11 00:38:34 | plainsongs | 1 | 67641 | 2 | 1.076 | 62863.4 |
95 | 2021-09-02 14:57:12 | plainsongs | 1 | 67641 | 2 | 1.046 | 64666.3 |
94 | 2021-07-01 10:57:56 | plainsongs | 1 | 67641 | 2 | 1.046 | 64666.3 |
93 | 2021-05-28 13:29:06 | plainsongs | 1 | 67641 | 2 | 1.156 | 58513.0 |
92 | 2021-05-06 01:45:59 | plainsongs | 1 | 67641 | 2 | 1.236 | 54725.7 |
91 | 2021-04-13 11:51:12 | plainsongs | 1 | 67641 | 2 | 1.110 | 60937.8 |
90 | 2021-01-27 04:22:55 | plainsongs | 1 | 67641 | 2 | 1.033 | 65480.2 |
89 | 2021-01-20 18:41:19 | plainsongs | 1 | 67641 | 2 | 1.140 | 59334.2 |
88 | 2020-11-16 14:47:09 | plainsongs | 1 | 67641 | 2 | 1.016 | 66575.8 |
87 | 2020-11-07 15:00:45 | plainsongs | 1 | 67641 | 2 | 1.156 | 58513.0 |
86 | 2020-10-22 12:30:19 | plainsongs | 1 | 67641 | 2 | 1.220 | 55443.4 |
85 | 2020-10-21 05:06:18 | plainsongs | 1 | 67641 | 2 | 1.033 | 65480.2 |
84 | 2020-10-17 20:30:29 | plainsongs | 1 | 67641 | 2 | 1.123 | 60232.4 |
83 | 2020-06-16 00:25:17 | plainsongs | 1 | 67641 | 2 | 1.063 | 63632.2 |
82 | 2020-03-26 20:54:17 | plainsongs | 1 | 67641 | 2 | 2.453 | 27574.8 |
81 | 2020-03-26 09:17:52 | plainsongs | 1 | 67641 | 2 | 1.373 | 49265.1 |
80 | 2020-03-06 22:12:00 | plainsongs | 1 | 67641 | 2 | 1.173 | 57665.0 |
79 | 2020-02-18 04:08:15 | plainsongs | 4 | 161450 | 83 | 13.706 | 11779.5 |
78 | 2020-02-18 01:37:54 | plainsongs | 1 | 67641 | 2 | 1.156 | 58513.0 |
77 | 2020-02-13 22:51:25 | plainsongs | 1 | 67641 | 2 | 1.266 | 53428.9 |
76 | 2020-02-12 09:21:33 | plainsongs | 4 | 161450 | 83 | 14.563 | 11086.3 |
75 | 2020-02-11 17:34:46 | plainsongs | 4 | 161450 | 83 | 16.233 | 9945.8 |
74 | 2020-02-08 19:20:23 | plainsongs | 1 | 67641 | 2 | 1.326 | 51011.3 |
73 | 2020-02-08 15:11:34 | plainsongs | 4 | 161450 | 83 | 12.780 | 12633.0 |
72 | 2020-02-07 10:42:48 | plainsongs | 4 | 161450 | 83 | 19.843 | 8136.4 |
71 | 2020-02-07 07:51:52 | plainsongs | 4 | 161450 | 83 | 15.233 | 10598.7 |
70 | 2020-02-07 02:37:36 | plainsongs | 1 | 67641 | 2 | 1.703 | 39718.7 |
69 | 2020-02-06 20:23:40 | plainsongs | 1 | 67641 | 2 | 1.173 | 57665.0 |
68 | 2020-02-06 02:04:43 | plainsongs | 1 | 67641 | 2 | 2.453 | 27574.8 |
67 | 2020-02-05 14:51:52 | plainsongs | 4 | 161450 | 83 | 24.453 | 6602.5 |
66 | 2020-02-05 06:56:33 | plainsongs | 1 | 67641 | 2 | 1.263 | 53555.8 |
65 | 2020-01-07 22:46:01 | plainsongs | 1 | 67641 | 2 | 1.283 | 52721.0 |
64 | 2020-01-06 16:27:47 | plainsongs | 1 | 67641 | 2 | 2.420 | 27950.8 |
63 | 2019-12-26 06:33:37 | plainsongs | 1 | 67641 | 2 | 1.186 | 57032.9 |
62 | 2019-11-16 21:24:47 | plainsongs | 1 | 67641 | 2 | 1.016 | 66575.8 |
61 | 2019-11-04 10:33:13 | plainsongs | 1 | 67641 | 2 | 1.093 | 61885.6 |
60 | 2019-09-12 15:19:53 | plainsongs | 1 | 67641 | 2 | 1.026 | 65926.9 |
59 | 2019-07-15 07:16:53 | plainsongs | 1 | 67641 | 2 | 0.976 | 69304.3 |
58 | 2019-06-27 07:27:46 | plainsongs | 1 | 67641 | 2 | 1.000 | 67641.0 |
57 | 2019-03-03 16:53:38 | plainsongs | 1 | 67641 | 2 | 0.946 | 71502.1 |
56 | 2019-01-11 02:18:52 | plainsongs | 1 | 67641 | 2 | 1.063 | 63632.2 |
55 | 2018-11-03 06:26:16 | plainsongs | 1 | 67641 | 2 | 1.056 | 64054.0 |
54 | 2018-10-18 16:52:15 | plainsongs | 1 | 67641 | 2 | 1.163 | 58160.8 |
53 | 2018-09-23 03:38:45 | plainsongs | 1 | 67641 | 2 | 1.120 | 60393.8 |
52 | 2018-09-17 02:40:15 | plainsongs | 1 | 67641 | 2 | 0.973 | 69518.0 |
51 | 2018-03-23 06:31:02 | plainsongs | 1 | 67641 | 2 | 2.266 | 29850.4 |
50 | 2017-12-03 22:27:36 | plainsongs | 1 | 67641 | 2 | 1.566 | 43193.5 |
49 | 2017-10-20 19:46:21 | plainsongs | 1 | 67641 | 2 | 1.710 | 39556.1 |
48 | 2016-10-05 16:36:12 | plainsongs | 1 | 67641 | 2 | 1.406 | 48108.8 |
47 | 2016-09-19 15:49:11 | plainsongs | 1 | 67641 | 2 | 1.566 | 43193.5 |
46 | 2016-09-14 14:27:16 | plainsongs | 3 | 140603 | 9 | 7.293 | 19279.2 |
45 | 2016-09-02 12:34:30 | plainsongs | 2 | 108824 | 2 | 3.513 | 30977.5 |
44 | 2016-08-27 16:39:30 | plainsongs | 1 | 67641 | 2 | 1.626 | 41599.6 |
43 | 2016-07-29 23:52:58 | plainsongs | 1 | 67641 | 2 | 1.753 | 38585.9 |
42 | 2016-07-06 06:14:14 | plainsongs | 1 | 67641 | 2 | 1.643 | 41169.2 |
41 | 2016-06-17 16:14:43 | plainsongs | 4 | 161450 | 83 | 36.936 | 4371.1 |
40 | 2016-06-16 21:39:18 | plainsongs | 5 | 173545 | 813 | 50.723 | 3421.4 |