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

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

65 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
mechanistically2782761mechanistically_
mechanically2455594mechan___ically_
cladistically2154945__cladistically_
hedonistically2354085he_donistically_
humanistically2463405_humanistically_
legalistically2053755le_galistically_
mechanistic2054375mechanistic_____
meristically1949015me___ristically_
moralistically2154765m_oralistically_
pianistically2056365__pianistically_
realistically1855965re__alistically_
socialistically2273215socialistically_
urbanistically2163445_urbanistically_
agonistically1955766__agonistically_
anchoritically2463596anchori_tically_
aphoristically2455056_aphoristically_
atavistically2175526__atavistically_
atheistically2166356_ath_eistically_
caustically1847136__c_a_ustically_
chaotically2148456__cha__otically_
communistically2682216communistically_
deistically1749046de____istically_
dualistically1995226__dualistically_
egoistically1867396_e__goistically_
egotistically1955516_e_gotistically_
elastically1649616_e_la__stically_
emphatically2456436empha___tically_
eristically16411346_e___ristically_
eulogistically2054066_eulogistically_
euphemistically2762026euphemistically_
euphuistically2462946_euphuistically_
fatalistically2254366_fatalistically_
faunistically2174256__faunistically_
fetishistically2662026fetishistically_
heuristically2155576he__uristically_
holistically2048116___holistically_
idealistically2053706_idealistically_
imagistically2155056__imagistically_
majestically2665406m___ajestically_
martensitically2261606martensitically_
masochistically2763026masochistically_
mechanical19115736mechan___ica_l__
mechanicals2093756mechan___ica_l_s
meiotically1849776me____iotically_
meroblastically2472696meroblastically_
metastatically2153466me_tastatically_
metathetically2454126me_tathetically_
monastically1948346m___onastically_
morganatically2263126morgan_atically_
organismically2262036_organismically_
pacifistically2653306pac_ifistically_
pedantically2056856pe_dan__tically_
pessimistically2461926pessimistically_
pharisaically2354136__pharisaically_
pluralistically2262946pluralistically_
ritualistically2092446ritualistically_
sadistically1847596___sadistically_
scholastically2454156_scholastically_
semantically1957886se_man__tically_
sophistically2356496soph__istically_
statistically1856356__statistically_
stochastically2463816stocha__stically_
technically2146446tech_n___ically_
theistically2067366__th_eistically_
unrealistically2062796unrealistically_

Search took 5 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 Filter178691658740.313570897.8
2DLD Change Limit65874654.50014638.7
3Display Results65650.0461413.0
 (SQL Overall)178691654.85936775.3
 
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.