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 “automated” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

70 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
automated124881(None) 
automate10411941automate_
automates11412051automates
automaker1544662automaker
automat9414872automat__
automata1047962automat_a
automatic13410392automatic
automatized23124912automatized
automaton1145372automaton
automats10410442automat_s
unautomated1453302unautomated
abrogated13126713abrogated
activated1567883activated
actuated1138743act_uated
advocated1644643advocated
allocated1248093allocated
animated111612373a_nimated
annotated1095613annotated
antedated1146703antedated
areolated1089713areolated
arrogated11147143arrogated
astomatal1144983astomatal
atomised11278833a_tomised
atomized20279323a_tomized
attempted1442563attempted
aurated83817793au__rated
autocade1146683autocade_
autocades1246793autocades
autoclaved1652103autoclaved
autoed7712823auto___ed
autografted1652363autografted
autolysed1384353autolysed
autolyzed2293873autolyzed
automakers1643873automakers
automan9310883automa__n
automatics1447783automatics
automating1389303automating
automation1249143automation
automatism14126433automatism
automatist12119053automatist
automatize2196563automatize
automatizes2296133automatizes
automatons1245373automatons
automen939653autom__en
autopsied1244353autopsied
autorotated1253483autorotated
bromated1339173_bromated
butylated1544183butylated
detonated1138213detonated
estimated12109443estimated
guttated10266873gut_tated
intimated121010893intimated
intonated1048303intonated
mutated102712253mut__ated
mutilated1239453mutilated
nonautomated1562513nonautomated
nutated83113423nut__ated
ostomate1049573ostomate_
ostomates1149343ostomates
outdated1012513193out_dated
outrated92219313out_rated
outskated14176833outskated
outsmarted1344323outsmarted
outstated10169813outstated
stomate9313123_stomate_
stomates10313343_stomates
summated13298833su_mmated
togated94410663__togated
ultimated1247313ultimated
unmated103317023_u_nmated

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.470380193.6
2DLD Change Limit148641706.86021667.8
3Display Results70700.0302333.3
 (SQL Overall)178691707.36024278.7
 
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.