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

108 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
actuations123929(None) 
actuation11310331actuation_
accusations1546002accusations
activations1669262activations
actuating1239232actuati_ng
actuators1146442actuat_ors
acylations1547602acylations
arcuations1249342arcuations
jactations1936892jact_ations
lactations1239422lact_ations
situations1038432situations
abductions15125383abductions
abjurations2045143abjurations
ablations11311513a_blations
ablutions1146603ablu_tions
abruptions1443843abruptions
accentuations1753093accentuations
accretions1444923accretions
accusation1466903accusation_
acetylations1743543acetylations
acidulations15104813acidulations
actions94218513ac___tions
activation15610133activation_
actualizes2145903actualizes
actuaries1147573actuari_es
actuates10310313actuat__es
actuator1046643actuat_o_r
acylation1448653acylation_
adductions14104953adductions
adjurations1944823adjurations
adnations1039753a_dnations
adorations11310243adorations
adulations11310123adulations
aerations9317903a_erations
agitations11310063agitations
agnations10310033a_gnations
alations82518893a__lations
alterations11511663alterations
ambulations1547113ambulations
amputations1546443amputations
angulations1268053angulations
animations12312193animations
annulations1167833annulations
antiquations2146243antiquations
arcuation11410583arcuation_
attentions1045983attentions
attenuations1243803attenuations
attractions1376403attractions
attritions1066793attritions
auctions104012143a__uctions
automations1348233automations
aviations12311553a_viations
avocations15168683avocations
carnations12311353carnations
caseations1258303caseations
cassations1276873cassations
castrations13410063castrations
catenations1348363catenations
cations94524143_c__ations
caudations13108223caudations
causations1268143causations
cautions103313183_cau_tions
citations11312503_citations
conations111318903_conations
creations112614543_creations
dictations1389703dict_ations
dotations101411633dot_ations
equations1839493_equations
evacuations1646303evac_uations
fetations12511383fet_ations
fluctuations1752563fluctuations
guttations1145593guttations
habituations1743113habituations
intubations1346833intubations
intuitions1047293intuitions
jactation1838143jact_ation_
jactitations2145013jactitations
lacerations1348333lacerations
lactation11310813lact_ation_
liquations1945623liquations
macerations1548473macerations
maculations1569623maculations
maturations1348443maturations
mutations111211453mut_ations
natations91412493nat_ations
nictations1278313nict_ations
nitrations10312033nitrations
notations91512973not_ations
nutations91411763nut_ations
obturations13116423obturations
occupations1744543occupations
potations111615073pot_ations
punctuations1643183punctuations
rotations91613843rot_ations
sacculations1646663sacculations
saltations10310623salt_ations
salutations1147643salutations
satiations10312113satiations
saturations1148573saturations
scalations1239783scalations
sinuations1039413sinuations
situation949423situation_
stations82415223_st_ations
titrations1039173titrations
tuitions838283__tuitions
vacations141910553vac__ations
valuations1348783valuations
vitiations1338743vitiations

Search took 7 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 Filter1786911406030.420425454.8
2DLD Change Limit1406031086.31322272.0
3Display Results1081080.0462347.8
 (SQL Overall)1786911086.77926359.5
 
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.