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

42 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
selenitic115691(None) 
elenctic1245882_elenctic
melanitic1346712melanitic
scleritic1345762scleritic
selenic9410662selen__ic
selenite81713112selenit_e
selenites91312092selenites
splenetic1345072splenetic
syenitic1346742s_yenitic
doleritic1245903doleritic
elenchic1544233_elenchic
elenchtic1642813_elenchtic
eremitic1248553_eremitic
felsitic1345033fel_sitic
lentic83515743__len_tic
melanistic1445873melanistic
melanotic1345393melanotic
pelitic111814653pel__itic
phlebitic1843683phlebitic
scleritis1146433scleritis
sclerotic1345753sclerotic
selenate81712533selenat_e
selenates91611363selenates
selenide9158873seleni_de
selenides10178203selenides
selenious946963selenious
selenium1048203seleni_um
seleniums1145823seleniums
selenosis945443selenosis
semantic1249553seman_tic
semeiotic1364653semeiotic
seniti64317223s__eniti_
serenities10411073serenities
serenity1168963serenit_y
sideritic1255353sideritic
solecistic1444743solecistic
splenetics1443413splenetics
splenic1148663splen__ic
splenii945543spleni_i_
stenotic1048083s_tenotic
sulfitic1345263sul_fitic
telestic10118953tele_stic

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 Filter1786911486410.436409841.7
2DLD Change Limit148641427.11020905.9
3Display Results42420.0162625.0
 (SQL Overall)178691427.56223630.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.