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

112 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
actuation1131033(None) 
actuations1239291actuations
accusation1466902accusation
activation15610132activation
actuating1239232actuating
actuator1046642actuat_or
acylation1448652acylation
arcuation11410582arcuation
jactation1838142jact_ation
lactation11310812lact_ation
situation949422situation
abduction14125413abduction
abjuration1945883abjuration
ablation10312433a_blation
ablution1047223ablu_tion
abruption1343973abruption
accentuation1653463accentuation
accretion1345933accretion
accusations1546003accusations
acetylation1643783acetylation
acidulation14105403acidulation
action84719683ac___tion
activations1669263activations
actuality1445803actuality
actualize2046353actualize
actuarial1144973actuarial
actuaries1147573actuaries
actuate9311443actuat__e
actuated1138743actuat_ed
actuates10310313actuat_es
actuators1146443actuators
acylations1547603acylations
adduction13225163adduction
adjuration1845523adjuration
adnation9310783a_dnation
adoration10311313adoration
adulation10311013adulation
aeration8319933a_eration
agitation10311223agitation
agnation9311723a_gnation
alation72920553a__lation
alteration10612903alteration
ambulation1447873ambulation
amputation1447343amputation
angulation1149553angulation
animation11313683animation
annulation1068953annulation
antiquation2047423antiquation
arcuations1249343arcuations
attention946103attention
attenuation1144183attenuation
attraction1276953attraction
attrition966963attrition
auction93412933a__uction
automation1249143automation
aviation11312743a_viation
avocation14168993avocation
carnation11312943carnation
caseation1199513caseation
cassation1197913cassation
castration12410803castration
catenation1249523catenation
cation83925503_c__ation
caudation1269993caudation
causation1199523causation
caution93013523_cau_tion
citation10314363_citation
conation101420883_conation
creation102816513_creation
dictation12810563dict_ation
dotation91412733dot_ation
equation17310483_equation
evacuation1547163evac_uation
fetation11613143fet_ation
fluctuation1653073fluctuation
guttation1046173guttation
habituation1643593habituation
intubation1247773intubation
intuition947623intuition
jactations1936893jact_ations
jactitation2045623jactitation
laceration1249573laceration
lactations1239423lact_ations
liquation1846553liquation
maceration1449613maceration
maculation14510983maculation
maturation1249513maturation
mutation101412883mut_ation
natation81513933nat_ation
nictation1189273nict_ation
nitration9313443nitration
notation81414603not_ation
nutation81513103nut_ation
obturation1297143obturation
occupation1645183occupation
potation101716783pot_ation
punctuation1543483punctuation
rotation81615453rot_ation
sacculation1547843sacculation
saltation9312003salt_ation
salutation1048903salutation
satiation9313433satiation
saturation1049803saturation
scalation11311073scalation
sinuation9310413sinuation
situations1038433situations
station72717243_st_ation
titration9310543titration
tuition738823__tuition
vacation131911893vac__ation
valuation1249973valuation
vitiation1239563vitiation

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.423422437.4
2DLD Change Limit1486411127.43619989.4
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.90522604.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.