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

59 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
dentalia94753(None) 
dental74319172dental__
dentality1348472dentality
dentalium1245332dentalium
dentally121110062dentally
dentals83915392dental_s
entasia73110062_entasia
genitalia1044022genitalia
battalia1045293battalia
cantala94114673cantal_a
centai84814783centa_i_
cental84420963cental__
centals94317053cental_s
contagia1156773contagia
deltaic1037023delta_ic
denari710917353den_ari_
denarii8389123den_arii
denial74720513denial__
denials84114133denial_s
dentaliums1343743dentaliums
dentate8315153denta_te
dentated10411703dentated
dentation10315243dentation
dentil74017883dent__il
dentiled1039743dentiled
dentils84115583dentil_s
dentin73919573dent__in
dentoid9310663dent_oid
destain8412083desta_in
detail74516433de_ta_il
details84214043de_tails
detain74617383de_ta_in
deutzia1743143deut_zia
dystaxia19123453dystaxia
entail61114343_enta_il
entails7912823_entails
entasias8269143_entasias
entasis73012573_entasis
entia5318203_ent__ia
fantasia1197013fantasia
genitalic1243923genitalic
mental84521603mental__
mentalism13511643mentalism
mentalist11515553mentalist
mentality1449133mentality
mentally131010403mentally
penetralia1254123penetralia
realia6314593re__alia
regalia839223re_galia
rental63922023rental__
rentals74017473rental_s
reptilia1045163reptilia
santalic1048893santalic
septaria1047413septaria
tantalic1048053tantalic
tentoria8119263tentoria
vedalia1145683ve_dalia
ventail10310453venta_il
ventails1139823ventails

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 Filter1786911461620.420425454.8
2DLD Change Limit146162597.20320291.8
3Display Results59590.0331787.9
 (SQL Overall)178691597.65623340.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.