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

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

53 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
anthropologists218341(None) 
anthropologist2064421anthropologist_
anthropologies20113982anthropologi_es
anthologists1648033anth___ologists
anthropological2373103anthropological
anthologist15410464anth___ologist_
anthropology2163544anthropolog___y
astrobiologists1873764ast_robiologists
chronologists1966114__chronologists
entomologists1655664ent__omologists
methodologists2153474meth_odologists
topologists1447864__t__opologists
angelologists1553375an__gelologists
anthologies151012015anth___ologi_es
anthologizes253038395anth___ologizes
anthropoids1755385anthrop__o_i_ds
anthropomorphs2672035anthropomo_rphs
anthropophagies2682345anthropophagi_es
anthroposophies2572135anthroposophies
antimonopolists19102075antimonopolists
antiroyalists1665095antiroyal__ists
apologists1348885a_____pologists
archaeologists20122815arch_aeologists
astrobiologist1784195ast_robiologist_
bacteriologists2063255bacter_iologists
chronologist1857625__chronologist_
entomologist1556975ent__omologist_
ethnologists1647045_eth__nologists
ethologists1549025_eth___ologists
futurologists1773075futur__ologists
horologists1548965___h_orologists
liturgiologists17141805liturgiologists
martyrologists2062895martyr__ologists
meteorologists1754185met_eorologists
methodologist2054315meth_odologist_
metrologists1588835met_r__ologists
mythologists2146895myth___ologists
narratologists1553215_narratologists
necrologists1547875_necr__ologists
nephrologists1954985nephr__ologists
neurobiologists18114315_neurobiologists
neurologists1347645_neur__ologists
ontologists1248905ont____ologists
pathologists1848375path___ologists
petrologists1559145pet_r__ologists
phonologists1848775__ph_onologists
phrenologists1956295__phrenologists
pteridologists18133725_pteridologists
teratologists1496595__teratologists
topologist13410645__t__opologist_
tribologists1546165__t_ribologists
tropologies1447735__t_ropologi_es
typologists1746815__t__ypologists

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.343520965.0
2DLD Change Limit65874533.90616864.8
3Display Results53530.0331606.1
 (SQL Overall)178691534.28241730.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.