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

122 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
actuating123923(None) 
activating1647862activating
actuation11310332actuation
actuations1239292actuations
acylating1547572acylating
lactating1239192lact_ating
situating1038882situating
abating10413973a__bating
abducting1584083abducting
ablating11312003a_blating
abutting1137003a_butting
accenting1487833accenting
accentuating1762833accentuating
accepting1695823accepting
accosting1446733accosting
accounting1544923accounting
accreting1446333accreting
accusing1336783accu_sing
acerbating1546293acerbating
acetylating1753283acetylating
acidulating1544293acidulating
acierating1348323acierating
acquaint1945723acqua_int
acquainting2352393acquainting
acquiring2144483acquiring
acquitting2243653acquitting
acting95920983ac___ting
actuality1445803actuality
actualize2046353actualize
actualizing2346203actualizing
actuarial1144983actuarial
actuaries1147573actuaries
actuate9311443actuat__e
actuated1138753actuat_ed
actuates10310313actuat_es
actuator1046643actuat_or
actuators1146443actuators
adducting1494303adducting
adjusting1843833adjusting
adulating1178723adulating
aerating92821003a_erating
agitating1138863agitating
ambulating1546373ambulating
amounting1236643amounting
amputating1545103amputating
angulating1247823angulating
animating12312513animating
antedating1277553antedating
antiaging1149673antiaging
antiquating2146433antiquating
aquatint1749433a_quatint
assuaging1144123assuaging
astatine8313533ast_atine
attenuating1253103attenuating
attesting1036383attesting
attracting1346563attracting
attriting1048693attriting
attuning935903attu_ning
automating1389303automating
aviating12311023a_viating
backdating2045723backdating
canulating1349553canulating
caseating12311743caseating
castrating1349773castrating
catenating1348683catenating
catfacing1744553catfacing
catting103922643cat__ting
caveating1539293caveating
cheating144014523_cheating
chuting132910733_chu_ting
cleating113518143_cleating
coating103525313_c_oating
counting113115273_counting
courting112514573_courting
crating103725203_c_rating
creating113921953_creating
crusting113612793_crusting
curating11314293_curating
cutting103817493_c_utting
dictating1338883dict_ating
equating18310113_equating
estating92614993est_ating
evacuating1645683evac_uating
extubating2044423extubating
fluctuating1752603fluctuating
habituating1743233habituating
intubating1376713intubating
intuiting1089613intuiting
jaculating2047303jaculating
lacerating1349453lacerating
liquating1946313liquating
macerating1549543macerating
maculating1549553maculating
maturating13108573maturating
micturating1644883micturating
mutating112211753mut_ating
nictating1237573nict_ating
nitrating10312673nitrating
notating92513343not_ating
nutating92411953nut_ating
obturating1346573obturating
occulting1445103occulting
octupling1443173octupling
outdating11810863outdating
outeating10814493outeating
outrating10916403outrating
punctuating1643103punctuating
rotating92614553rot_ating
satiating10311813satiating
saturating11119203saturating
scouting112612753scou_ting
sinuating1039683sinuating
stating83725163_st_ating
stunting92811503_stunting
tauting83316383__tauting
titrating10310113titrating
tufting11289873__tufting
tutting83515913__tutting
vacating14310363vac__ating
valuating1338653valuating
victualing1643403victualing
vitiating1338413vitiating

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.440406115.9
2DLD Change Limit1486411227.29620372.9
3Display Results1221220.0602033.3
 (SQL Overall)1786911227.79622920.9
 
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.