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

74 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
vitriols114505(None) 
vitriol1045691vitriol_
estriols856252estriols
nitrils72810702nitri_ls
triols66117802__triols
vibrions1345092vibrions
vibrios1235802vibrio_s
virions1039872vi_rions
vitreous1145842vitreous
vitrics12198552vitri_cs
vitrines112610912vitrines
vitrioled1343422vitrioled
vitriolic1443032vitriolic
citrals91111673citr_als
citreous1056853citreous
citrines102513133citrines
citrins92614363citri_ns
citrons92913223citr_ons
citrous93112993citr_ous
dithiol1145433dithiol_
estriol747553estriol_
fibrils1236843fibri_ls
mistrials1148133mistrials
nitinols844413nitinols
nitrides92910703nitrides
nitrids8269633nitri_ds
nitril62511533nitri_l_
nitrile73011373nitri_le
nitriles8269923nitriles
nitrites82313453nitrites
nitros64214123nitr_o_s
nitrous73512483nitr_ous
oestriols944333oestriols
patriots1038053patriots
patrols93513513patr_ols
petrols92913083petr_ols
retrials8510823retrials
thiols95112763__thiols
trials64319883__trials
trills64319853__trills
triol55521363__triol_
trios55528093__trio_s
variola1068893v_ariola
variolas1168533v_ariolas
variole10711593v_ariole
varioles11711123v_arioles
various103113103v_arious
vibrio1136223vibrio__
vibrioid1444403vibrioid
vibrion1245253vibrio_n
vibrioses1443923vibrioses
vibriosis1443923vibriosis
vicarious1445583vicarious
vicious1239493vi_cious
victorious1543413victorious
vigils104210193vi_gi_ls
viols86118103v___iols
vireos94212453vi_reo_s
virile9313433vi_ri_le
virion9310683vi_rio_n
virls85618603vi_r__ls
viroids1137923vi_roids
virtuous1144663virtuous
visions10311023vi_sions
vitals94514303vit__als
vitrains1138283vitrains
vitric112510113vitri__c
vitrifies1547223vitrifies
vitriform1743323vitriform
vitrify1645003vitri_fy
vitrine102511363vitri_ne
vitrioling1443583vitrioling
vitriolled1451663vitriolled
wittols1035733wit_tols

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 Limit146162747.97018339.0
3Display Results74740.0302466.7
 (SQL Overall)178691748.42321214.7
 
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.