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 “antisentimentala” with Change Limit: [1] [2] [3] [4] [5] [6] [7] [8]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

31 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
antisentimental177951antisentimental_
unsentimental1572254un__sentimental_
presentimental1861925_presentimental_
sentimental1355345____sentimental_
sentimentally1874146____sentimentally
adjustmental2261207adjus__t_mental_
anointment1256467anoi__nt_ment___
anointments1355437anoi__nt_ment__s
antinational1297487anti_nati_on_al_
antirational1278497anti_rati_on_al_
antiseptically2163707antisepti__cally
antistudent1253417antis__tudent___
attentional1154207a_t_tenti_on_al_
environmental18131767environ__mental_
epicontinental1871127_epicontinental_
insentient1049427in__senti_ent___
intentional11128857int__enti_on_al_
intersegmental1762377interse__gmental_
nonsedimentable2071407_nonse_dimentable
presentiment1654457_presentiment___
presentiments1753027_presentiment__s
ressentiment1473367_ressentiment___
ressentiments1582847_ressentiment__s
sentiently1346077____senti_ent_ly
sentiment11410727____sentiment___
sentimentalise16164797____sentimentalise
sentimentalism18145117____sentimentalism
sentimentalist16155457____sentimentalist
sentimentality1963807____sentimentality
sentimentalize25164077____sentimentalize
sentiments1248277____sentiment__s

Search took 10 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.360496363.9
2DLD Change Limit95024319.11010430.7
3Display Results31310.0161937.5
 (SQL Overall)178691319.48618837.3
 
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.