History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shots"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1110 | 2025-11-24 07:13:59 | shots | 1 | 28756 | 27 | 1.406 | 20452.3 |
| 1109 | 2025-11-23 22:47:42 | shots | 2 | 53800 | 263 | 1.686 | 31909.8 |
| 1108 | 2025-11-23 11:02:43 | shots | 2 | 53800 | 263 | 2.216 | 24278.0 |
| 1107 | 2025-11-18 13:37:00 | shots | 1 | 28756 | 27 | 0.563 | 51076.4 |
| 1106 | 2025-11-16 07:35:42 | shots | 1 | 28756 | 27 | 0.530 | 54256.6 |
| 1105 | 2025-11-15 16:05:59 | shots | 1 | 28756 | 27 | 0.576 | 49923.6 |
| 1104 | 2025-11-15 04:14:21 | shots | 1 | 28756 | 27 | 0.530 | 54256.6 |
| 1103 | 2025-11-14 17:48:32 | shots | 1 | 28756 | 27 | 1.030 | 27918.4 |
| 1102 | 2025-11-13 23:47:33 | shots | 1 | 28756 | 27 | 1.403 | 20496.1 |
| 1101 | 2025-11-11 17:27:48 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
| 1100 | 2025-11-11 03:45:11 | shots | 1 | 28756 | 27 | 0.483 | 59536.2 |
| 1099 | 2025-11-02 12:25:04 | shots | 1 | 28756 | 27 | 2.733 | 10521.8 |
| 1098 | 2025-10-31 11:34:12 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
| 1097 | 2025-10-29 12:34:47 | shots | 2 | 53800 | 263 | 1.766 | 30464.3 |
| 1096 | 2025-10-29 06:55:26 | shots | 1 | 28756 | 27 | 0.546 | 52666.7 |
| 1095 | 2025-10-26 23:50:11 | shots | 1 | 28756 | 27 | 0.580 | 49579.3 |
| 1094 | 2025-10-24 23:35:53 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
| 1093 | 2025-10-24 14:23:48 | shots | 1 | 28756 | 27 | 0.533 | 53951.2 |
| 1092 | 2025-10-23 01:41:03 | shots | 1 | 28756 | 27 | 2.233 | 12877.7 |
| 1091 | 2025-10-21 10:49:14 | shots | 1 | 28756 | 27 | 1.390 | 20687.8 |
| 1090 | 2025-10-20 04:42:24 | shots | 2 | 53800 | 263 | 1.546 | 34799.5 |
| 1089 | 2025-10-20 03:40:30 | shots | 1 | 28756 | 27 | 0.456 | 63061.4 |
| 1088 | 2025-10-19 23:02:20 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
| 1087 | 2025-10-18 11:32:26 | shots | 1 | 28756 | 27 | 0.610 | 47141.0 |
| 1086 | 2025-10-18 11:21:44 | shots | 1 | 28756 | 27 | 1.640 | 17534.1 |
| 1085 | 2025-10-17 07:33:21 | shots | 1 | 28756 | 27 | 0.546 | 52666.7 |
| 1084 | 2025-10-12 16:35:34 | shots | 1 | 28756 | 27 | 0.970 | 29645.4 |
| 1083 | 2025-10-11 09:32:45 | shots | 1 | 28756 | 27 | 1.030 | 27918.4 |
| 1082 | 2025-10-10 23:32:45 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
| 1081 | 2025-10-08 23:55:55 | shots | 1 | 28756 | 27 | 0.516 | 55728.7 |
| 1080 | 2025-10-03 05:14:40 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
| 1079 | 2025-09-27 21:33:14 | shots | 1 | 28756 | 27 | 0.513 | 56054.6 |
| 1078 | 2025-09-26 17:19:04 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
| 1077 | 2025-09-25 05:07:46 | shots | 1 | 28756 | 27 | 1.376 | 20898.3 |
| 1076 | 2025-09-25 05:07:46 | shots | 1 | 28756 | 27 | 1.233 | 23322.0 |
| 1075 | 2025-09-25 04:30:48 | shots | 1 | 28756 | 27 | 2.063 | 13938.9 |
| 1074 | 2025-09-20 03:12:24 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
| 1073 | 2025-09-14 12:03:16 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
| 1072 | 2025-09-13 02:29:40 | shots | 1 | 28756 | 27 | 0.546 | 52666.7 |
| 1071 | 2025-09-08 21:34:34 | shots | 1 | 28756 | 27 | 0.466 | 61708.2 |
| 1070 | 2025-09-07 10:10:23 | shots | 1 | 28756 | 27 | 0.466 | 61708.2 |
| 1069 | 2025-09-06 18:05:01 | shots | 1 | 28756 | 27 | 0.546 | 52666.7 |
| 1068 | 2025-09-06 09:01:36 | shots | 1 | 28756 | 27 | 0.483 | 59536.2 |
| 1067 | 2025-09-04 14:23:50 | shots | 1 | 28756 | 27 | 0.516 | 55728.7 |
| 1066 | 2025-09-02 11:54:00 | shots | 1 | 28756 | 27 | 0.513 | 56054.6 |
| 1065 | 2025-08-31 15:14:50 | shots | 1 | 28756 | 27 | 0.470 | 61183.0 |
| 1064 | 2025-08-27 11:24:42 | shots | 1 | 28756 | 27 | 0.486 | 59168.7 |
| 1063 | 2025-08-25 12:42:25 | shots | 1 | 28756 | 27 | 2.220 | 12953.2 |
| 1062 | 2025-08-19 16:40:47 | shots | 1 | 28756 | 27 | 1.940 | 14822.7 |
| 1061 | 2025-08-14 13:50:50 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
| 1060 | 2025-08-10 07:47:44 | shots | 1 | 28756 | 27 | 2.360 | 12184.7 |
| 1059 | 2025-08-04 15:05:10 | shots | 1 | 28756 | 27 | 0.546 | 52666.7 |
| 1058 | 2025-08-01 09:40:46 | shots | 1 | 28756 | 27 | 1.110 | 25906.3 |
| 1057 | 2025-07-31 23:37:12 | shots | 2 | 53800 | 263 | 3.873 | 13891.0 |
| 1056 | 2025-07-31 13:04:54 | shots | 1 | 28756 | 27 | 0.546 | 52666.7 |
| 1055 | 2025-07-27 12:29:46 | shots | 1 | 28756 | 27 | 2.796 | 10284.7 |
| 1054 | 2025-07-26 14:45:52 | shots | 1 | 28756 | 27 | 2.440 | 11785.2 |
| 1053 | 2025-07-23 00:46:09 | shots | 1 | 28756 | 27 | 3.533 | 8139.3 |
| 1052 | 2025-07-22 20:56:48 | shots | 1 | 28756 | 27 | 1.660 | 17322.9 |
| 1051 | 2025-07-18 23:56:24 | shots | 1 | 28756 | 27 | 0.530 | 54256.6 |
| 1050 | 2025-07-10 18:20:34 | shots | 1 | 28756 | 27 | 2.750 | 10456.7 |
| 1049 | 2025-07-04 14:23:03 | shots | 1 | 28756 | 27 | 1.406 | 20452.3 |
| 1048 | 2025-06-30 12:45:35 | shots | 1 | 28756 | 27 | 1.470 | 19561.9 |
| 1047 | 2025-06-30 12:03:44 | shots | 1 | 28756 | 27 | 3.643 | 7893.5 |
| 1046 | 2025-06-28 08:58:34 | shots | 1 | 28756 | 27 | 2.516 | 11429.3 |
| 1045 | 2025-06-16 17:21:05 | shots | 1 | 28756 | 27 | 0.966 | 29768.1 |
| 1044 | 2025-06-16 04:05:44 | shots | 1 | 28756 | 27 | 1.736 | 16564.5 |
| 1043 | 2025-06-11 12:27:47 | shots | 1 | 28756 | 27 | 2.906 | 9895.4 |
| 1042 | 2025-06-01 05:53:42 | shots | 2 | 53800 | 263 | 12.173 | 4419.6 |
| 1041 | 2025-05-30 09:22:32 | shots | 1 | 28756 | 27 | 1.376 | 20898.3 |
| 1040 | 2025-05-30 06:26:27 | shots | 2 | 53800 | 263 | 6.283 | 8562.8 |
| 1039 | 2025-05-29 10:27:07 | shots | 1 | 28756 | 27 | 1.470 | 19561.9 |
| 1038 | 2025-05-29 08:22:08 | shots | 1 | 28756 | 27 | 1.390 | 20687.8 |
| 1037 | 2025-05-26 15:15:55 | shots | 1 | 28756 | 27 | 3.813 | 7541.6 |
| 1036 | 2025-05-19 20:23:07 | shots | 1 | 28756 | 27 | 3.233 | 8894.5 |
| 1035 | 2025-05-17 08:13:53 | shots | 1 | 28756 | 27 | 2.876 | 9998.6 |
| 1034 | 2025-05-16 16:36:09 | shots | 1 | 28756 | 27 | 4.060 | 7082.8 |
| 1033 | 2025-05-11 18:32:01 | shots | 1 | 28756 | 27 | 0.716 | 40162.0 |
| 1032 | 2025-05-11 12:25:54 | shots | 1 | 28756 | 27 | 1.626 | 17685.1 |
| 1031 | 2025-05-08 11:02:02 | shots | 1 | 28756 | 27 | 1.250 | 23004.8 |
| 1030 | 2025-05-08 11:00:22 | shots | 1 | 28756 | 27 | 1.233 | 23322.0 |
| 1029 | 2025-05-08 10:56:36 | shots | 1 | 28756 | 27 | 2.530 | 11366.0 |
| 1028 | 2025-05-08 10:41:37 | shots | 1 | 28756 | 27 | 2.390 | 12031.8 |
| 1027 | 2025-05-08 10:40:50 | shots | 1 | 28756 | 27 | 2.376 | 12102.7 |
| 1026 | 2025-05-05 03:36:36 | shots | 1 | 28756 | 27 | 1.596 | 18017.5 |
| 1025 | 2025-04-30 12:00:49 | shots | 1 | 28756 | 27 | 1.703 | 16885.5 |
| 1024 | 2025-04-28 08:05:20 | shots | 1 | 28756 | 27 | 3.606 | 7974.5 |
| 1023 | 2025-04-19 07:30:30 | shots | 1 | 28756 | 27 | 0.530 | 54256.6 |
| 1022 | 2025-04-16 13:08:32 | shots | 1 | 28756 | 27 | 2.390 | 12031.8 |
| 1021 | 2025-04-13 21:36:26 | shots | 1 | 28756 | 27 | 1.576 | 18246.2 |
| 1020 | 2025-04-11 12:18:05 | shots | 1 | 28756 | 27 | 1.156 | 24875.4 |
| 1019 | 2025-04-08 05:25:34 | shots | 1 | 28756 | 27 | 0.516 | 55728.7 |
| 1018 | 2025-04-07 07:40:28 | shots | 1 | 28756 | 27 | 2.436 | 11804.6 |
| 1017 | 2025-03-31 16:22:17 | shots | 1 | 28756 | 27 | 1.280 | 22465.6 |
| 1016 | 2025-03-30 23:13:30 | shots | 1 | 28756 | 27 | 2.893 | 9939.9 |
| 1015 | 2025-03-14 23:02:25 | shots | 1 | 28756 | 27 | 1.313 | 21901.0 |
| 1014 | 2025-03-14 21:46:50 | shots | 1 | 28756 | 27 | 0.893 | 32201.6 |
| 1013 | 2025-03-13 10:00:08 | shots | 1 | 28756 | 27 | 2.203 | 13053.1 |
| 1012 | 2025-03-12 08:24:53 | shots | 1 | 28756 | 27 | 1.376 | 20898.3 |
| 1011 | 2025-03-08 09:12:27 | shots | 1 | 28756 | 27 | 1.390 | 20687.8 |