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

28 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
geotectonically23111601geotectonically_
tectonically1946324___tectonically_
electronically2163835_e_lectronically_
geocentrically2263315geocent_rically_
geometrically2155515geome_t_rically_
geotechnical2082385geotec_hnica_l__
geotectonic1652125geotectonic_____
geotropically2154925geot__ropically_
biomechanically2971866biomechanically_
catatonically2054156_cat_atonically_
eclectically1855476_eclect__ically_
ectopically2047126____ectopically_
egocentrically2263346egocent_rically_
egotistically1955516egotist__ically_
electrically1965686_e_lect_rically_
genealogically2163126ge_nealogically_
genetically1759206ge_ne_t__ically_
geochemically2654846geo__chemically_
geologically1947366geo___logically_
gnotobiotically2381626gnotobiotically_
isotonically1756056iso___tonically_
meteorically1956816me_te__orically_
monotonically2055326_mo_notonically_
pyrotechnically3072166pyrotec_hnically_
semitonically2074756se__mitonically_
technically2146446___tec_hnically_
telephonically2462466te_lephonically_
tetanically1648066___te_tanically_

Search took 6 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.326548131.9
2DLD Change Limit65874284.79613735.2
3Display Results28280.033848.5
 (SQL Overall)178691285.15534663.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.