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

88 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
anthropologies2011398(None) 
anthropologist2064422anthropologist
anthropologists2183412anthropologists
anthologies151012013anth___ologies
anthropological2373103anthropological
anthropology2163543anthropolog__y
anthropophagies2682333anthropophagies
anthroposophies2572133anthroposophies
tropologies1447723__t_ropologies
andrologies1346114an_dr__ologies
anthologizes253038394anth___ologizes
anthropoids1755384anthrop__o_ids
anthropometries22122684anthropometries
anthropomorphs2672034anthropomorphs
astrobiologies1763264ast_robiologies
astrologies1247924ast_r__ologies
chronologies1846404__chronologies
entomologies1575324ent__omologies
methodologies2053484meth_odologies
topologies1348974__t__opologies
acarologies1446055a_car__ologies
aerobiologies1655055a__erobiologies
aerologies11312025a__er__ologies
aetiologies1248985aet___iologies
agrologies1237695a__gr__ologies
amphibologies2352415amph_ibologies
anemologies1446925an___emologies
angelologies1453015an__gelologies
angiologies1346135an___giologies
anthologist15410465anth___ologist
anthologists1648035anth___ologists
anthologize24128065anth___ologize
anthologized26126975anth___ologized
anthologizer25156915anth___ologizer
anthologizers26145495anth___ologizers
anthropogenic2162985anthropogeni_c
anthropoid1656465anthrop__o_i_d
anthropomorph2572125anthropomo_rph
anthropophagi2472425anthropophagi__
anthropophagous2681825anthropophagous
anthropophagus2582205anthropophagus
anthroposophy2672045anthroposo_phy
antilogies11410315ant____ilogies
apologies12311195a_____pologies
archaeologies1952825arch_aeologies
archeologies1845005arch__eologies
areologies1139825a___r_eologies
arthropathies2163115arthrop_athies
arthroscopies2064225arthro_scopies
autecologies1554575aut__ecologies
bacteriologies1952825bacter_iologies
carpologies1646405__car_pologies
cohomologies2054055_coh_omologies
ethnologies1547985_eth__nologies
ethologies14310545_eth___ologies
futurologies1652425futur__ologies
geochronologies2261995geochronologies
homologies16311515___h_omologies
horologies14411055___h_orologies
lithologies1546835lith___ologies
liturgiologies1661215liturgiologies
martyrologies1952335martyr__ologies
meteorologies1653585met_eorologies
metrologies1449585met_r__ologies
mythologies2047845myth___ologies
narratologies1452755_narratologies
necrologies1447985_necr__ologies
nephrologies1845075nephr__ologies
neurobiologies1763915_neurobiologies
neurologies1248235_neur__ologies
nomologies1339475_n___omologies
nosologies1148105_n___osologies
ontologies1139885ont____ologies
pathobiologies2274195pathobiologies
pathologies1748735path___ologies
petrologies1449895pet_r__ologies
phonologies17410005__ph_onologies
phrenologies1846315__phrenologies
pteridologies1762935_pteridologies
soteriologies1453875soter_iologies
stereologies1345915_ster_eologies
teratologies1346875__teratologies
theologies141010105__th__eologies
tocologies1349765__t__ocologies
tokologies1547145__t__okologies
tribologies1446115__t_ribologies
tropologic1556065__t_ropologi_c
typologies1647645__t__ypologies

Search took 7 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 Filter178691950240.1101624463.6
2DLD Change Limit95024886.64014310.8
3Display Results88880.0631396.8
 (SQL Overall)178691886.81326227.9
 
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.