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

58 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
determinant145473(None) 
determinants1553471determinants
determinacy1953082determinacy
determinantal1661902determinantal
determinate1446622determinate
determining1545292determining
determinist1455202determinist
determent121312903determ__ent
determinable1754023determinable
determinably2053543determinably
determinator1554573determinator
determine1249033determi__ne
determined1455823determin_ed
determiner1345483determin_er
determiners1444643determiners
determines1358433determin_es
determinism1654063determinism
determinists1553703determinists
germinant1246183__germinant
alternant977134alter__nant
deferment151210304deferm__ent
degerming1435754degermi__ng
deperming1537114depermi__ng
detergent11129574deter__gent
deterging1237854detergi__ng
determents131010314determen_ts
determinacies1853194determinacies
determinately1953194determinately
determination1657644determination
determinations1766894determinations
determinative1954074determinative
determinators1653894determinators
determinedly1952494determinedly
determinisms1753354determinisms
deterministic1862414deterministic
deterrent10128944deter__rent
deterring1138624deterri__ng
detoxicant2053484det_oxicant
detraining1267674det_raining
detrainment1495384det_rainment
detriment1249694det_r_iment
discriminant17113184discriminant
dominant1149524d___ominant
examinant1844604_e_xaminant
exterminate2054544exterminate
extermining2154044extermining
indeterminacy2161984indeterminacy
indeterminate1652984indeterminate
indeterminist1693094indeterminist
preterminal1554584pretermina_l
redetermining1752314redetermining
setenant849934sete___nant
sterilant947284_ster_ilant
termagant1244454__termagant
terminal1039734__termina_l
terminals1147464__terminals
terminate11411204__terminate
veterinary1652864veter_inary

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 Filter1786911488190.423422437.4
2DLD Change Limit148819588.67017164.8
3Display Results58580.0501160.0
 (SQL Overall)178691589.14319544.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.