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

182 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
actuate931144(None) 
actuated1138741actuated
actuates10310311actuates
acuate8315631ac_uate
acaudate1145972acaudate
accurate12410662accurate
acerate92818912acerate
acetate92514752acetate
activate13510372activate
actual8311022actua_l
actuary1245612actuary
actuator1046642actuator
acute74720362ac_u_te
acylate12310532acylate
arcuate9311962arcuate
astute6310762astu_te
lactate9312692lact_ate
scutate9310322scutate
situate7410782situate
abate76627843a__bate
ablate82219213a_blate
accentuate1453523accentuate
accrete1137843accrete
accuse103411033accu_se
acerated113113983acerated
acerbate1247533acerbate
acervate1336983acervate
acetated112010683acetated
acetates102013063acetates
acetylate1444213acetylate
achiote1239213achiote
aciculate132510803aciculate
acidulate12256893acidulate
acierate10311813acierate
acolyte12157653acolyte
aconite9315473aconite
acquire1835603acquire
acquit17610323acquit_
acquits1857293acquits
acreage1037843acreage
acrylate1347693acrylate
acta69524803act_a__
actable11313473actable
activated1567883activated
activates1449683activates
active11313743act_ive
actuality1445803actuality
actualize2046353actualize
actually1366853actually
actuaries1147563actuaries
actuating1239223actuating
actuation11310333actuation
actuators1146443actuators
acuity1139373ac_uity
aculeate1039923aculeate
acutance1246303acutance
acuter84412863ac_u_ter
acutes83917723ac_u_tes
acylated1437873acylated
acylates1339743acylates
adequate1844303adequate
adnate72913483a_dnate
adulate8313233adulate
aerate64830553a_erate
agate66525153a__gate
agemate101210583agemate
agitate8312063agitate
agnate73314883a_gnate
airdate8311323airdate
alate55340323a__late
ambulate1239733ambulate
amirate91115953amirate
amputate1246263amputate
angulate9312013angulate
animate91617213animate
annulate8310923annulate
ansate64517863a_nsate
antae56828293ant_a_e
anteater8311603anteater
antedate949693antedate
antiquate1888033antiquate
aquae142212713a_qua_e
arbute8311043arbu_te
arcuated1138803arcuated
artiste73813693artiste
assuage835683assuage
atlatl637873a_tlatl
attenuate974473attenuate
attrite7311833attrite
attune637983attu_ne
aurate64426473a_urate
aureate72515283aureate
automate10411943automate
autunite856693autunite
aviate9315203a_viate
baccate131011263bac_cate
backdate1748223backdate
bracteate1345353bracteate
canulate10314553canulate
carate84734003_carate
caseate9314783caseate
castrate10313863castrate
cate66254603_c__ate
catenate10312833catenate
catface1436763catface
caudate10311353caudate
cerate84829463_cerate
chute104316463_chu_te
citrate92216803citrate
comate104124843_comate
crate76537403_c_rate
create85126383_create
curate85226243_curate
cute66440453_c_u_te
dictate10311663dict_ate
ecaudate1145313ecaudate
eluate62315433_eluate
equate152012463_equate
estate64719763est_ate
evacuate13217303evac_uate
extubate1745103extubate
factual1246723factua_l
facture12108923factu_re
fluctuate1443113fluctuate
guttate8328903guttate
habituate1443923habituate
hastate10313913hast_ate
intubate1047533intubate
jaculate172311783jaculate
lacerate102214703lacerate
lactase937953lact_ase
lactated1138863lact_ated
lactates10311223lact_ates
lacunate10128963lacunate
liquate1638423liquate
macerate122314073macerate
maculate122815623maculate
maturate10312613maturate
metate82720533met_ate
micturate1366643micturate
mutate83017483mut_ate
nictate9310223nict_ate
nitrate72017013nitrate
notate63217863not_ate
nutate63017373nut_ate
obturate1077773obturate
ocreate93711743ocreate
octane81411633oct_ane
octave11157343oct_ave
octette946423octette
octuple1153993octuple
outate62923403out_ate
outdate83016423outdate
outrate72323183outrate
pectate112214693pect_ate
punctuate1343743punctuate
quate144521413__quate
racemate1239063racemate
rotate63320343rot_ate
saccate111311763sac_cate
sacculate1349023sacculate
satiate7315403satiate
saturate8312813saturate
scutage1036333scutage
scute75520943sc_u_te
sinuate7412163sinuate
situated938033situated
situates8310373situates
state56237333_st_ate
tactual936203tactua_l
tartrate899683tartrate
tate44748603__t_ate
titrate72215573titrate
toluate7159343toluate
tractate10411003tract_ate
tubate82813173__tubate
ustulate868323ustulate
vacate11314553vac__ate
valuate102512733valuate
vitiate103412953vitiate
vittate10409733vittate
xanthate1845713xanthate

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 Filter1786911340270.830215290.4
2DLD Change Limit1340271827.81317154.4
3Display Results1821820.0762394.7
 (SQL Overall)1786911828.71920494.4
 
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.