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

56 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
anthropological2373101anthropological_
anthological1847514anth___ological_
anthropologies20113984anthropologi__es
anthropologist2064424anthropologi__st
anthropologists2183414anthropologi_sts
tropological1746634__t_ropological_
unchronological2362324unchronological_
anthropical1855355anthrop____ical_
anthropology2163545anthropolog____y
astrological1547025ast_r__ological_
chronological2175955__chronological_
entomological1855035ent__omological_
methodological2353305meth_odological_
topological1647435__t__opological_
tropologically2264185__t_ropologically
aerobiological1955136a__erobiological_
anthropogenic2162986anthropogenic___
antilogical1447276ant____ilogical_
antipolitical1764056ant__ipolitical_
archaeological22152936arch_aeological_
astrologically2055436ast_r__ologically
autecological1854436aut__ecological_
bacteriological2282866bacter_iological_
chronologically2663546__chronologically
cohomological2354086_coh_omological_
entomologically2363206ent__omologically
ethnological1846816_eth__nological_
ethological1748196_eth___ological_
futurological1952986futur__ological_
homological1948456___h_omological_
horological1748286___h_orological_
lithological1845896lith___ological_
meteorological1953786met_eorological_
metrological1748376met_r__ological_
mythological2346906myth___ological_
narratological1763096_narratological_
necrological1747286_necr__ological_
neurobiological20123926_neurobiological_
neurological1547336_neur__ological_
nomological1648076_n___omological_
nontheological2063216nonth__eological_
nosological1447376_n___osological_
ontological1448316ont____ological_
pathological2047986path___ological_
petrological1758596pet_r__ological_
phonological2058376__ph_onological_
phrenological2156336__phrenological_
pteridological2053596_pteridological_
soteriological1763896soter_iological_
stereological1655676_ster_eological_
teratological1656116__teratological_
theological1798266__th__eological_
topologically2165396__t__opologically
tribological1745986__t_ribological_
tropologic1556066__t_ropologic___
typological1946686__t__ypological_

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.330541487.9
2DLD Change Limit65874564.95313299.8
3Display Results56560.0461217.4
 (SQL Overall)178691565.32933531.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.