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

29 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
neuropathology237238(None) 
neuropathologic2391932neuropathologic
neuropsychology2981663neuropsychology
neuroradiology1971403neuroradiology
histopathology2671494histopathology
immunopathology28141454immunopathology
neonatology1553164ne__onat_ology
neurobiology1863174neuro__biology
neuropathy1853844neuropath____y
neurophysiology2791624neurophysiology
paleopathology25101804paleopathology
phytopathology3172154phytopathology
dermatology1853925de_r_mat_ology
gerontology1653365ge_ro_nt_ology
herpetology2053065he_r_pet_ology
narratology1552385n_ar_rat_ology
nematology16125205ne___mat_ology
nephology1865965ne___p__hology
neurology1346575neur_____ology
neuropath1454535neuropath_____
neuropathic1854685neuropath___ic
neuropathically25122985neuropathically
neuropathies1764105neuropath__ies
neuropaths1554275neuropath____s
pathology1846935_____pathology
physiopathology3281295physiopathology
pneumatology20102605pneu__mat_ology
psychopathology3481845psychopathology
teratology1445295te_r__at_ology

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.373479064.3
2DLD Change Limit95024296.03315750.7
3Display Results29290.0132230.8
 (SQL Overall)178691296.41927837.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.