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

46 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
ethicist134789(None) 
ethicists1445441ethicists
atticist10811342atticist
ethician1346602ethician
ethicize2246282ethicize
ethics11169282ethic_s_
atheist10314063ath_eist
athirst1037873athi_rst
atticism1268533atticism
atticists1167943atticists
bioethicist1852973bioethicist
chicest14209943_chicest
elicit8417203e_lici_t
elicits9311233e_licits
elitist7414913e_litist
eroticist11712073eroticist
etatist7415033et_atist
etherish1448273etherish
ethic101511223ethic___
ethical1238443ethic_al
ethicals1345533ethicals
ethicians1445283ethicians
ethicized2444933ethicized
ethicizes2345863ethicizes
ethions1038483ethions_
ethnicity1744593ethnicity
ethnics1236263ethnic_s_
euthenist1249033euthenist
exhibit1945253exhibi_t
exhibits2044143exhibits
exorcist1746873exorcist
exoticist1887993exoticist
gothicism1743793gothicism
lyricist13718983lyricist
methodist1547013methodist
metricism1557513metricism
nihilist1147163nihilist
opticist1248923opticist
stoicism1246873stoicism
theist9314763_th_eist
thickest17337303_thickest
thicket163213073_thicket
thickish2044603_thickish
thicks154511993_thicks_
thickset17257133_thickset
thirst9312253_thi_rst

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 Filter1786911461620.423422437.4
2DLD Change Limit146162466.43622710.1
3Display Results46460.0162875.0
 (SQL Overall)178691466.87525991.4
 
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.