History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"johns"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1101 | 2025-07-11 16:19:52 | johns | 1 | 28756 | 4 | 3.436 | 8369.0 |
1100 | 2025-07-08 18:34:00 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
1099 | 2025-07-04 20:44:07 | johns | 1 | 28756 | 4 | 3.296 | 8724.5 |
1098 | 2025-07-02 05:27:56 | johns | 1 | 28756 | 4 | 2.033 | 14144.6 |
1097 | 2025-06-20 05:05:55 | johns | 1 | 28756 | 4 | 2.483 | 11581.2 |
1096 | 2025-06-16 11:56:22 | johns | 1 | 28756 | 4 | 0.936 | 30722.2 |
1095 | 2025-06-13 23:58:49 | johns | 2 | 53800 | 78 | 8.203 | 6558.6 |
1094 | 2025-06-13 06:16:11 | johns | 1 | 28756 | 4 | 0.470 | 61183.0 |
1093 | 2025-06-08 11:59:04 | johns | 2 | 53800 | 78 | 8.330 | 6458.6 |
1092 | 2025-06-05 23:55:02 | johns | 2 | 53800 | 78 | 7.923 | 6790.4 |
1091 | 2025-06-03 20:42:30 | johns | 1 | 28756 | 4 | 3.733 | 7703.2 |
1090 | 2025-06-02 05:28:51 | johns | 1 | 28756 | 4 | 3.000 | 9585.3 |
1089 | 2025-06-02 04:33:04 | johns | 1 | 28756 | 4 | 2.343 | 12273.2 |
1088 | 2025-05-27 20:56:03 | johns | 1 | 28756 | 4 | 0.560 | 51350.0 |
1087 | 2025-05-27 03:29:16 | johns | 1 | 28756 | 4 | 2.440 | 11785.2 |
1086 | 2025-05-17 04:21:17 | johns | 1 | 28756 | 4 | 3.470 | 8287.0 |
1085 | 2025-05-16 06:40:39 | johns | 3 | 83667 | 1401 | 15.813 | 5291.0 |
1084 | 2025-05-14 18:18:06 | johns | 3 | 83667 | 1401 | 9.800 | 8537.4 |
1083 | 2025-05-14 13:49:44 | johns | 3 | 83667 | 1401 | 19.550 | 4279.6 |
1082 | 2025-05-12 07:22:14 | johns | 1 | 28756 | 4 | 1.936 | 14853.3 |
1081 | 2025-05-12 07:00:42 | johns | 3 | 83667 | 1401 | 15.876 | 5270.0 |
1080 | 2025-05-11 00:12:07 | johns | 3 | 83667 | 1401 | 18.076 | 4628.6 |
1079 | 2025-05-07 23:19:02 | johns | 1 | 28756 | 4 | 3.266 | 8804.7 |
1078 | 2025-05-05 16:26:24 | johns | 1 | 28756 | 4 | 0.483 | 59536.2 |
1077 | 2025-05-03 20:33:32 | johns | 1 | 28756 | 4 | 2.123 | 13545.0 |
1076 | 2025-04-19 20:07:53 | johns | 1 | 28756 | 4 | 0.986 | 29164.3 |
1075 | 2025-04-18 04:49:46 | johns | 1 | 28756 | 4 | 1.766 | 16283.1 |
1074 | 2025-04-16 11:40:02 | johns | 1 | 28756 | 4 | 2.403 | 11966.7 |
1073 | 2025-04-16 07:44:36 | johns | 1 | 28756 | 4 | 1.560 | 18433.3 |
1072 | 2025-04-12 06:41:30 | johns | 1 | 28756 | 4 | 3.796 | 7575.3 |
1071 | 2025-04-06 11:30:15 | johns | 2 | 53800 | 78 | 3.610 | 14903.0 |
1070 | 2025-04-01 23:19:30 | johns | 2 | 53800 | 78 | 6.296 | 8545.1 |
1069 | 2025-03-31 14:50:25 | johns | 2 | 53800 | 78 | 10.486 | 5130.7 |
1068 | 2025-03-31 06:54:03 | johns | 1 | 28756 | 4 | 1.330 | 21621.1 |
1067 | 2025-03-31 06:50:08 | johns | 3 | 83667 | 1401 | 26.220 | 3191.0 |
1066 | 2025-03-30 05:03:16 | johns | 1 | 28756 | 4 | 1.266 | 22714.1 |
1065 | 2025-03-29 14:15:25 | johns | 3 | 83667 | 1401 | 30.656 | 2729.2 |
1064 | 2025-03-27 19:32:35 | johns | 3 | 83667 | 1401 | 25.016 | 3344.5 |
1063 | 2025-03-24 13:17:31 | johns | 3 | 83667 | 1401 | 3.843 | 21771.3 |
1062 | 2025-03-17 10:37:12 | johns | 1 | 28756 | 4 | 1.033 | 27837.4 |
1061 | 2025-03-14 23:20:53 | johns | 1 | 28756 | 4 | 1.016 | 28303.1 |
1060 | 2025-03-13 00:17:30 | johns | 1 | 28756 | 4 | 2.000 | 14378.0 |
1059 | 2025-03-06 17:17:38 | johns | 3 | 83667 | 1401 | 17.690 | 4729.6 |
1058 | 2025-02-27 23:47:47 | johns | 3 | 83667 | 1401 | 18.906 | 4425.4 |
1057 | 2025-02-27 22:18:27 | johns | 3 | 83667 | 1401 | 21.266 | 3934.3 |
1056 | 2025-02-27 22:18:26 | johns | 2 | 53800 | 78 | 10.606 | 5072.6 |
1055 | 2025-02-27 21:27:59 | johns | 1 | 28756 | 4 | 0.513 | 56054.6 |
1054 | 2025-02-27 21:25:05 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
1053 | 2025-02-27 21:04:10 | johns | 1 | 28756 | 4 | 2.846 | 10104.0 |
1052 | 2025-02-24 22:09:30 | johns | 2 | 53800 | 78 | 3.736 | 14400.4 |
1051 | 2025-02-24 15:20:03 | johns | 2 | 53800 | 78 | 7.546 | 7129.6 |
1050 | 2025-02-24 13:13:39 | johns | 2 | 53800 | 78 | 7.173 | 7500.3 |
1049 | 2025-02-24 02:48:14 | johns | 3 | 83667 | 1401 | 19.563 | 4276.8 |
1048 | 2025-02-21 02:23:27 | johns | 3 | 83667 | 1401 | 19.516 | 4287.1 |
1047 | 2025-02-19 07:41:06 | johns | 3 | 83667 | 1401 | 9.360 | 8938.8 |
1046 | 2025-02-18 16:47:05 | johns | 3 | 83667 | 1401 | 11.330 | 7384.6 |
1045 | 2025-02-09 13:16:49 | johns | 1 | 28756 | 4 | 1.186 | 24246.2 |
1044 | 2025-02-03 15:14:40 | johns | 1 | 28756 | 4 | 1.406 | 20452.3 |
1043 | 2025-01-28 09:39:05 | johns | 1 | 28756 | 4 | 0.453 | 63479.0 |
1042 | 2025-01-27 22:26:22 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
1041 | 2025-01-20 08:13:45 | johns | 1 | 28756 | 4 | 2.576 | 11163.0 |
1040 | 2025-01-09 21:29:36 | johns | 1 | 28756 | 4 | 3.453 | 8327.8 |
1039 | 2024-12-30 22:50:00 | johns | 3 | 83667 | 1401 | 15.126 | 5531.3 |
1038 | 2024-12-29 10:14:25 | johns | 3 | 83667 | 1401 | 21.453 | 3900.0 |
1037 | 2024-12-29 09:52:24 | johns | 2 | 53800 | 78 | 1.623 | 33148.5 |
1036 | 2024-12-29 09:16:59 | johns | 3 | 83667 | 1401 | 17.423 | 4802.1 |
1035 | 2024-12-29 09:17:01 | johns | 2 | 53800 | 78 | 7.736 | 6954.5 |
1034 | 2024-12-29 07:55:45 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
1033 | 2024-12-28 19:08:02 | johns | 1 | 28756 | 4 | 2.453 | 11722.8 |
1032 | 2024-12-27 10:35:44 | johns | 1 | 28756 | 4 | 1.313 | 21901.0 |
1031 | 2024-12-09 16:23:39 | johns | 1 | 28756 | 4 | 2.190 | 13130.6 |
1030 | 2024-12-04 06:58:40 | johns | 2 | 53800 | 78 | 7.970 | 6750.3 |
1029 | 2024-11-30 05:02:51 | johns | 3 | 83667 | 1401 | 13.190 | 6343.2 |
1028 | 2024-11-29 03:29:30 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
1027 | 2024-11-29 01:58:56 | johns | 2 | 53800 | 78 | 4.423 | 12163.7 |
1026 | 2024-11-28 20:35:26 | johns | 3 | 83667 | 1401 | 17.346 | 4823.4 |
1025 | 2024-11-28 18:42:40 | johns | 3 | 83667 | 1401 | 18.876 | 4432.5 |
1024 | 2024-11-28 16:33:56 | johns | 3 | 83667 | 1401 | 16.126 | 5188.3 |
1023 | 2024-11-28 16:33:53 | johns | 2 | 53800 | 78 | 9.343 | 5758.3 |
1022 | 2024-11-28 16:13:44 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
1021 | 2024-11-27 05:59:16 | johns | 1 | 28756 | 4 | 1.580 | 18200.0 |
1020 | 2024-11-08 16:13:49 | johns | 3 | 83667 | 1401 | 17.876 | 4680.4 |
1019 | 2024-11-08 16:05:00 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
1018 | 2024-11-08 14:51:26 | johns | 2 | 53800 | 78 | 6.623 | 8123.2 |
1017 | 2024-11-08 00:37:31 | johns | 2 | 53800 | 78 | 8.393 | 6410.1 |
1016 | 2024-11-08 00:29:22 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
1015 | 2024-11-01 06:45:35 | johns | 1 | 28756 | 4 | 2.110 | 13628.4 |
1014 | 2024-10-30 02:47:16 | johns | 2 | 53800 | 78 | 7.890 | 6818.8 |
1013 | 2024-10-30 02:36:46 | johns | 1 | 28756 | 4 | 0.483 | 59536.2 |
1012 | 2024-10-29 16:09:51 | johns | 3 | 83667 | 1401 | 12.706 | 6584.8 |
1011 | 2024-10-29 14:38:43 | johns | 3 | 83667 | 1401 | 19.393 | 4314.3 |
1010 | 2024-10-29 02:30:48 | johns | 3 | 83667 | 1401 | 13.830 | 6049.7 |
1009 | 2024-10-29 02:30:47 | johns | 2 | 53800 | 78 | 4.653 | 11562.4 |
1008 | 2024-10-29 02:29:57 | johns | 1 | 28756 | 4 | 1.140 | 25224.6 |
1007 | 2024-10-24 01:39:41 | johns | 1 | 28756 | 4 | 2.266 | 12690.2 |
1006 | 2024-10-24 01:31:42 | johns | 1 | 28756 | 4 | 1.390 | 20687.8 |
1005 | 2024-10-18 08:26:07 | johns | 1 | 28756 | 4 | 1.560 | 18433.3 |
1004 | 2024-10-09 10:53:19 | johns | 1 | 28756 | 4 | 0.923 | 31154.9 |
1003 | 2024-09-29 18:42:48 | johns | 2 | 53800 | 78 | 5.640 | 9539.0 |
1002 | 2024-09-29 17:51:23 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |