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

154 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
actuated113875(None) 
actuate9311441actuate_
actuates10310311actuates
acerated113114002acerated
acetated112010692acetated
activated1567882activated
actuator1046642actuator
acuate8315632ac_uate_
acylated1437882acylated
arcuated1138812arcuated
lactated1138872lact_ated
situated938032situated
abated95918453a__bated
abducted1444093abducted
ablated102513443a_blated
abluted10188363ablu_ted
abutted1056983a_butted
acaudate1145973acaudate_
accented13107803accented
accentuated1652703accentuated
accepted15105413accepted
accosted1345543accosted
accounted1444833accounted
accreted1336353accreted
accurate12410663accurate_
accursed1354643accursed
accused12368433accu_sed
acerate92818913acerate_
acerbated1465563acerbated
acetate92514753acetate_
acetates102013063acetates
acetylated1643163acetylated
acidulated14195153acidulated
acierated1238303acierated
acquainted2252003acquainted
acquired2044043acquired
acquitted2143503acquitted
acted88521743ac___ted
activate13510373activate_
activates1449683activates
actual8311023actua__l
actualized2245343actualized
actually1366853actually
actuaries1147573actuaries
actuary1245613actua_ry
actuating1239233actuating
actuation11310333actuation
actuators1146443actuators
aculeated1247733aculeated
acute74720363ac_u_te_
acuter84412863ac_u_ter
acutes83917723ac_u_tes
acylate12310533acylate_
acylates1339743acylates
adducted1343913adducted
adjusted1743613adjusted
adulated1039753adulated
aerated85322383a_erated
agitated1038413agitated
alated75625153a__lated
ambulated1457133ambulated
amounted1135533amounted
amputated1444463amputated
angulated1139223angulated
animated111612373animated
annulated1038603annulated
ansated84214003a_nsated
anteater8311603anteater
antedated1146713antedated
antiquated2055483antiquated
arcuate9311963arcuate_
assuaged1044383assuaged
astute6310763astu_te_
attenuated1183223attenuated
attested936313attested
attracted1246073attracted
attrited947373attrited
attuned835173attu_ned
aurated83817793a_urated
automated1248813automated
aviated11310263a_viated
baccated15148383bac_cated
backdated1946483backdated
canulated12310673canulated
caseated11310723caseated
castrated1239523castrated
catenated1238923catenated
catted95422473cat__ted
caudated1238063caudated
caveated1439143caveated
cerated103922473_cerated
cheated134416353_cheated
chuted124611843_chu_ted
citrated112712253citrated
cleated103417853_cleated
coated94927043_c_oated
counted103815803_counted
courted103514923_courted
crated94827773_c_rated
created104323463_created
crusted103712763_crusted
curated104717583_curated
dictated1239203dict_ated
equated171910403_equated
estated83715573est_ated
evacuated15196263evac_uated
extubated1944133extubated
fluctuated1642493fluctuated
guttated10266873guttated
habituated1643053habituated
intubated1246453intubated
intuited938763intuited
jaculated19289053jaculated
lacerated122210693lacerated
lactate9312703lact_ate_
lactates10311233lact_ates
liquated1835493liquated
macerated142010533macerated
maculated142411503maculated
maturated1249173maturated
micturated1584993micturated
mutated102712253mut_ated
nictated1137793nict_ated
nitrated92213153nitrated
notated82713663not_ated
nutated83113423nut_ated
obturated1245953obturated
occulted1344273occulted
octupled1343503octupled
outdated1012513193outdated
outrated92219323outrated
punctuated1543373punctuated
rotated82715293rot_ated
sacculated1546623sacculated
satiated9311603satiated
saturated1039003saturated
scouted104112033scou_ted
scutate9310323scutate_
sinuated938413sinuated
situate7410783situate_
situates8310373situates
stated75427833_st_ated
stunted83010403_stunted
tartrated1096653tartrated
tauted75317113__tauted
teated74924023__teated
titrated92611683titrated
tufted10359283__tufted
tutted75117443__tutted
untufted1236083untufted
vacated1349353vac__ated
valuated12239203valuated
victualed1543103victualed
vitiated12289223vitiated

Search took 9 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.406440125.6
2DLD Change Limit1461621548.03018202.0
3Display Results1541540.0801925.0
 (SQL Overall)1786911548.51620983.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.