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

48 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
dominative167739(None) 
nominative1597681nominative
combinative2055132combinative
denominative1854402denominative
diminutive1653392diminutive
dominate11312852dominat__e
dominating1449402dominating
domination13712372domination
donative12139872do__native
nominatives1694772nominatives
ruminative1546432ruminative
carminative1844893carminative
cogitative1645933cogitative
combative1847213com_bative
conative131214623co__native
definitive1745083definitive
delineative1554663delineative
denominatives1952653denominatives
derivative1746683derivative
designative1654333designative
detonative1447133detonative
deviative1647723devi_ative
dilative1239523d__ilative
diminutives1752583diminutives
dominance1446213domina_nce
dominated1339883dominat_ed
dominates12311743dominat_es
dominations14611043dominations
dominator1258233dominat_or
dominators1397483dominators
dominatrices1751803dominatrices
dominatrix2052053dominatrix
dominie103111643domin__i_e
donatives13146903do__natives
eliminative1654363eliminative
emanative1447313_emanative
germinative1755043germinative
imitative1446333_imitative
limitative1544693limitative
motivative1844283motivative
nominate10312473nominat__e
nominating1349503nominating
nomination12712103nomination
nonnative1248343no_nnative
oxidative2044313_oxidative
terminative1656133terminative
urinative1247653_urinative
vomitive1645853vomi__tive

Search took 7 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 Filter1786911406030.423422437.4
2DLD Change Limit140603486.09323076.2
3Display Results48480.0301600.0
 (SQL Overall)178691486.54627297.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.