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

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

50 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
necrologist1441013(None) 
necrologists1547871necrologists
neurologist1249981neurologist
ecologist12314142_ec_ologist
metrologist14511232metrologist
necrologies1447992necrologies
neologist10712812ne__ologist
nephrologist1856302nephrologist
neurologists1347642neurologists
petrologist14711882petrologist
serologist11413152se_rologist
cetologist13412253ce_tologist
dendrologist1555093dendrologist
ecologists13310923_ec_ologists
electrologist1657053electrologist
enologist10314123_e_nologist
ethologist14411893_ethologist
fetologist14410403fe_tologist
gemmologist1746543gemmologist
gemologist141010283ge_mologist
geologist11611783ge__ologist
gynecologist1954573gynec_ologist
horologist14412363_horologist
hydrologist1948333hydrologist
metrologists1588833metrologists
mycologist18410353myc_ologist
necrological1747283necrological
necrology1546223necrolog__y
necropolis1455293necropolis_
nematologist15208473nematologist
neologism1247483ne__ologism
neologists1139773ne__ologists
nephrologists1954983nephrologists
neurologic1346803neurologi_c
neurologies1248243neurologies
numerologist1574913numerologist
oncologist13410413onc_ologist
orologist10313103__orologist
pedologist14410863pe_dologist
penologist13412843pe_nologist
petrologists1559143petrologists
prologist12315083__prologist
semiologist14410713semiologist
serologists12410123se_rologists
sexologist1849513se_xologist
sociologist1449883sociologist
technologist18137403technologist
teleologist1249383teleologist
urologist10411053__urologist
virologist1448813_virologist

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 Filter1786911216330.376475242.0
2DLD Change Limit121633505.51622050.9
3Display Results50500.0301666.7
 (SQL Overall)178691505.92230174.1
 
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.