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

87 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
activated156788(None) 
activate13510371activate_
activates1449681activates
activator1446442activator
activized2445192activized
actuated1138742act_uated
aestivated14106292aestivated
captivated1844762captivated
deactivated1843732deactivated
estivated13108322estivated
inactivated1744552inactivated
motivated1545962motivated
reactivated1744972reactivated
titivated1345442titivated
abdicated1547013abdicated
acclimated1745153acclimated
acerated113113983ac_erated
acerbated1465553acerbated
acervate1336983acervate_
acetated112010683ac_etated
acetylated1643163acetylated
acierated1238283acierated
activating1647853activating
activation15610133activation
activators1545943activators
active11313743activ__e_
actives12311523activ__es
activities1548903activities
activity1647583activit_y
activize2246613activize_
activizes2346323activizes
actuate9311443act_uate_
actuates10310303act_uates
aculeated1247713aculeated
acuminated1545873acuminated
acylated1437863ac_ylated
aestivate12127663aestivate_
aestivates13107353aestivates
agitated1038413a_gitated
animated111612373a_nimated
antedated1146693antedated
antidoted1146723antidoted
antiquated2055483antiquated
aspirated1247703aspirated
automated1248803automated
aviated11310263a_vi_ated
capitated14159043capitated
captivate1645923captivate_
captivates1745493captivates
carinated123414263carinated
castigated1446323castigated
catenated1238913catenated
cavitated15177353cavitated
citrated112712243_citrated
cultivated1645673cultivated
deactivate1644623deactivate_
deactivates1744393deactivates
echinated1546483echinated
estimated12109443estimated
estivate111010003estivate_
estivates12109743estivates
inactivate1545693inactivate_
inactivates1645043inactivates
intimated121010883intimated
lactated1138863lact__ated
litigated1146563litigated
machinated1845663machinated
masticated1548233masticated
mitigated1347083mitigated
motivate1347693motivate_
motivates1447073motivates
mutilated1239453mutilated
nictitated1344393nictitated
nonactivated1853613nonactivated
passivated1644143passivated
patinated123911413patinated
reactivate1545843reactivate_
reactivates1645613reactivates
salivated1337473salivated
satiated9311603sati_ated
titivate1146803titivate_
titivates1246433titivates
tittivated1442903tittivated
ultimated1247303ultimated
urticated1247693urticated
vaccinated1855443vaccinated
vitiated12289223viti_ated

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.266671770.7
2DLD Change Limit148641876.84321721.6
3Display Results87870.0461891.3
 (SQL Overall)178691877.15524974.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.