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

45 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
dialectologist188268(None) 
dialectologists1992391dialectologists
diabetologist17133142diabe_tologist
dialectologies1892082dialectologies
diabetologists18122813diabe_tologists
dialectological2162093dialectological
dialectology1961773dialectolog__y
electrologist1657044__electrologist
malacologist1755634_malac_ologist
paleontologist1765144_paleontologist
planetologist1664504plane_tologist
algologist1248245__al__gologist
biotechnologist2371565biotechnologist
cetologist13412255___ce_tologist
cosmetologist1853975cosme_tologist
deontologist1457415d__eontologist
dermatologist1786465d_ermatologist
dialogist1148275dia_____logist
ecclesiologist1962605ecclesiologist
ecologist12314145____ec_ologist
electrologists1765645__electrologists
fetologist14410405___fe_tologist
glaciologist1654895__glaciologist
gynecologist1954575_gynec_ologist
herpetologist1984795herpe_tologist
histologist1547985hi___stologist
ideologist1248535_i_de__ologist
lichenologist1973915liche_nologist
malacologists1854405_malac_ologists
malariologist1693925_malariologist
myrmecologist2353315myrmec_ologist
narratologist1453835_narratologist
necrologist14410125___necrologist
paleobiologist19156345_paleobiologist
paleoecologist19114725_paleoecologist
paleontologists1884525_paleontologists
paleozoologist2664195_paleozoologist
palynologist1856305_pal_ynologist
planetologists1763625plane_tologists
proctologist1758965__proctologist
sedimentologist1992115sedi_mentologist
selenologist1357005_sele_nologist
speleologist1555745spele__ologist
teleologist1249385_tele__ologist
thanatologist1753615tha_natologist

Search took 8 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.376475242.0
2DLD Change Limit95024457.04613486.2
3Display Results45450.0301500.0
 (SQL Overall)178691457.45223978.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.