Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “jaculated” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
jaculated1928905(None) 
ejaculated20165901ejaculated
jaculate172311781jaculate_
jaculates182810361jaculates
maculated142411501maculated
aculeated1247722_aculeated
acylated1437872_acylated
adulated1039752_adulated
calculated1577802calculated
canulated12310672canulated
ejaculate18187162ejaculate_
ejaculates19166442ejaculates
fabulated1546322fabulated
jugulated1844022jugulated
loculated1288312loculated
maculate122815622maculate_
maculates132013722maculates
osculated1298142osculated
peculated142310852peculated
sacculated1546622sacculated
tabulated1237302tabulated
vacuolated1643972vacuolated
ablated102513443_a_blated
acerated113113983_acerated
acetated112010683_acetated
acidulated14195153_acidulated
actuated1138743_actuated
acuate8315633_acu_ate_
aculeate1039923_aculeate_
acylate12310533_acylate_
acylates1339743_acylates
adulate8313233_adulate_
adulates9311913_adulates
alated75625153_a__lated
ambulated1457133ambulated
angulated1139223angulated
annulated1038603annulated
arcuated1138803arcu_ated
aurated83817793_a_urated
baccated15148373bac_cated
backdated1946483backdated
calculate1389873calculate_
calculates1498703calculates
cannulated1346503cannulated
canulate10314553canulate_
canulates11312873canulates
capsulated1545653capsulated
caudated1238063ca_udated
circulated1588063circulated
coagulated1496533coagulated
copulated142710483copulated
cumulated14237843cumulated
curated104717583__curated
ejaculator1944133ejaculator
emasculated1644533emasculated
emulated11310793_emulated
escalated1247303escalated
evacuated15196263evacu_ated
exculpated2243923exculpated
fabulate1339203fabulate_
fabulates1447733fabulates
faculae123210353facula_e_
faulted11227723fa_ul_ted
granulated1256943granulated
gratulated1255733gratulated
hamulate1359013hamulate_
incubated1446983incubated
inculcated1546173inculcated
inculpated1545733inculpated
inoculated1347593inoculated
insulated10310713insulated
jacketed22146533jac_keted
jaculating2047303jaculating
jaunted15418563ja_u_nted
jubilated1944933jubilated
jugulate1645483jugulate_
jugulates1744603jugulates
lacerated122210683lacerated
lactated1138873lac_tated
lacunate10128963lacunate_
ligulated11247363ligulated
lobulated12106423lobulated
loculate101011403loculate_
lunulated1036783lunulated
macerated142010523macerated
maculae113412863macula_e_
maculed123510053macul__ed
maturated1249163maturated
modulated1336713modulated
occulted1344263occul_ted
osculate101010613osculate_
osculates11109393osculates
ovulated1237083_ovulated
peculate122414673peculate_
peculates132112543peculates
populated14228803populated
regulated11310463regulated
sacculate1349023sacculate_
saturated1038993saturated
sculpted1354883_sculpted
simulated1238283simulated
speculated15186613speculated
tabulate10310893tabulate_
tabulates1139143tabulates
tegulated1146633tegulated
tubulated1256063tubulated
ululated947663_ululated
undulated11310083undulated
vacated1349353vac__ated
vacillated1654633vacillated
vacuolate1445223vacuolate_
valuated12239203valu_ated
vaulted11307193va_ul_ted

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.436409841.7
2DLD Change Limit1486411137.31320325.6
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.79522923.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.