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

63 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
hymnists164490(None) 
hymnist1546631hymnist_
chymists18285602chym_ists
gymnasts1442432gymnasts
hornists11208832hornists
humanists1446842humanists
hygeists1543542hygeists
hymnodists1952832hymnodists
agonists9289833agonists
bemists113410703bem_ists
cambists1437023cambists
chemists152710323chem_ists
chymist17268173chym_ist_
cyclists1545713cyclists
demonists1248703demonists
dynasts1155103dy_nasts
feminists14227623feminists
gymnast1344153gymnast_
harmonists15137123harmonists
harpists1338103harpists
hedonists1346053hedonists
heists96814633h__eists
hists86328373h___ists
hoists95516023h__oists
holists104413963h_olists
homilists1456813homilists
hornist102314823hornist_
humanises1448313humanises
humanisms1646683humanisms
humanist13410493humanist_
humorists1445783humorists
hybrises1645423hybrises
hygeist1445793hygeist_
hygieists1642603hygieists
hygienists1752333hygienists
hymeniums1973473hymeniums
hymnals1543523hymn_als
hymning1635183hymni_ng
hymnless1632803hymnless
hymnodist1844203hymnodist_
hymns1337523hymn___s
hypnoses1646633hypnoses
hypnosis1646533hypnosis
hypnotists1853883hypnotists
ironists839293ironists
kyanises15206393kyanises
luminists1147173luminists
lyrists1036963ly_rists
maists85817573__maists
mists76633903__m_ists
monists93614783_monists
onanists838413onanists
pianists1049013pianists
plenists1038253plenists
shamanists1544323shamanists
simonists1146763simonists
sumoists1046733sumoists
symbiots1573623symbiots
tanists7313653_tanists
tennists8297793tennists
tympanists1743103tympanists
typists1236173ty_pists
womanists1446763womanists

Search took 9 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 Limit146162637.62619166.3
3Display Results63630.0302100.0
 (SQL Overall)178691638.07922118.0
 
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.