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

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

51 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
dissentients135422(None) 
dissentient1256951dissentient_
dissentions12168042dissention_s
discontents1447543discont_ents
dissections14198263dissection_s
dissensions12175573dissension_s
dissenters1197723dissent_e_rs
dissenting121310293dissenti_n_g
dissention11188073dissention__
dissentious12184473dissenti_ous
dissepiments1753463dissepiments
distentions12178843distention_s
insentient1049423_insentient_
ressentiments1582843ressentiments
sentients948463___sentients
descendents1554144descen_dents
disbandments1853444disbandments
discernments1785194discernments
discontent13410254discont_ent_
disenchants1753184di_senchants
disentitles1255264di_sentitles
disorients1177794di_s_orients
disownments17114904disown_ments
disportments1755354disportments
disseating121111784disseati_n_g
dissecting14139474dissecti_n_g
dissection13158614dissection__
disseisins1145954disseisi_n_s
disseizins2044544disseizi_n_s
dissension11135724dissension__
dissented1199724dissent_e__d
dissenter1059134dissent_e__r
dissents93411864diss____ents
dissepiment1654304dissepiment_
disserting121310854disserti_n_g
disseverments19123184disseverments
dissidents1245024diss__idents
dissolvents1553114diss_olvents
distensions12146274distension_s
distention11158874distention__
divestments17155164di_vestments
dizenments2244974di_zen_ments
insentience1355524_insentience
insentiences1455464_insentiences
presentient1348324presentient_
presentiments1753024presentiments
presentments1654304presentments
resentments1346544_resentments
ressentiment1473364ressentiment_
sentient8313634___sentient_
sentiments1248274___sentiments

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 Filter1786911247900.406440125.6
2DLD Change Limit124790517.42016818.1
3Display Results51510.0331545.5
 (SQL Overall)178691517.85922737.1
 
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.