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 “jaculate” 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.

153 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
jaculate17231178(None) 
ejaculate18187161ejaculate
jaculated19289051jaculated
jaculates182810361jaculates
maculate122815621maculate
acuate8315632_acu_ate
aculeate1039922_aculeate
acylate12310532_acylate
adulate8313232_adulate
calculate1389872calculate
canulate10314552canulate
ejaculated20165902ejaculated
ejaculates19166442ejaculates
fabulate1339202fabulate
faculae123210352facula_e
hamulate1359012hamulate
jugulate1645482jugulate
lacunate10128962lacunate
loculate101011402loculate
maculae113412862macula_e
maculated142411502maculated
maculates132013722maculates
osculate101010612osculate
peculate122414672peculate
sacculate1349022sacculate
tabulate10310892tabulate
vacuolate1445222vacuolate
ablate82219213_a_blate
acaudate1145973_acaudate
accurate12410663accurate
acerate92818913_acerate
acetate92514753_acetate
aciculate132510803aciculate
acidulate12256893_acidulate
acolyte12157653_acolyte
acrylate1347693_acrylate
actuate9311443_actuate
aculeated1247723_aculeated
acute74720363_acu__te
acylated1437873_acylated
acylates1339743_acylates
adulated1039753_adulated
adulates9311913_adulates
alate55340333_a__late
alulae6312743_alula_e
ambulate1239733ambulate
angulate9312013angulate
annulate8310923annulate
apiculate13279883apiculate
arcuate9311963arcu_ate
aurate64426473_a_urate
baccate131011263bac_cate
backdate1748223backdate
bacula103112673bacula__
baculine1238983baculine
calculated1577803calculated
calculates1498703calculates
cannulate1148633cannulate
canulae9311183canula_e
canulated12310673canulated
canulates11312873canulates
capsulate1347563capsulate
caudate10311353ca_udate
circulate13810433circulate
coagulate1258083coagulate
copulate122614113copulate
cucullate1344733cucullate
cumulate123110223cumulate
cupulate122810033cupulate
curate85226243__curate
ecaudate1145313ecaudate
ejaculator1944133ejaculator
emasculate1445553emasculate
emulate9314123_emulate
escalate1039323escalate
evacuate13217303evacu_ate
exculpate2044833exculpate
fabulated1546323fabulated
fabulates1447733fabulates
faceplate1645223faceplate
facula112912233facula__
facular122810443facula_r
faculty1535573facul_ty
feculae12339203fecula_e
gallate83417133ga_llate
granulate1059183granulate
gratulate1047683gratulate
haulage1136913ha_ulage
immaculate1653503immaculate
incubate1238663incubate
incudate1138873incudate
inculcate1347433inculcate
inculpate1346793inculpate
inoculate1149623inoculate
insulate8312843insulate
jackplane2443003jackplane
jaculating2047303jaculating
jocular1637303jocula_r
jubilate1746553jubilate
jugate14379463j__ugate
jugulated1844023jugulated
jugulates1744603jugulates
lacerate102214713lacerate
lactate9312703lac_tate
lacunae9116803lacuna_e
lazulite1745033lazulite
ligulate92510253ligulate
lobulate1078833lobulate
loculated1288313loculated
lunulate838253lunulate
macerate122314073macerate
macula103013673macula__
macular113011943macula_r
maculas113114023macula_s
macule104115273macul__e
malate84624563ma__late
maturate10312623maturate
modulate1138593modulate
osculated1298143osculated
osculates11109393osculates
ovulate1039453_ovulate
palate84226793pa__late
paniculate1447213paniculate
papulae11249353papula_e
peculated142310853peculated
peculates132112543peculates
planulate1146903planulate
populate122812093populate
racemate1239063racemate
radulae837963radula_e
regulate9313023regulate
rosulate8310903rosulate
saccate111311763sac_cate
sacculated1546623sacculated
saturate8312813saturate
scutate9310323_scutate
simulate10311133simulate
spatulate11107173spatulate
speculate13239193speculate
spiculate132210163spiculate
subulate10312743subulate
tabulated1237303tabulated
tabulates1139143tabulates
tubulate1038273tubulate
ululate749963_ululate
undulate9310403undulate
ungulate939803ungulate
ustulate868323ustulate
vacate11314553vac__ate
vacillate1456853vacillate
vacuolated1643973vacuolated
vallate103016563va_llate
valuate102512733valu_ate

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621536.78021557.8
3Display Results1531530.0632428.6
 (SQL Overall)1786911537.26624592.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.