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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
determinate144662(None) 
determinable1754022determinable
determinacy1953082determinacy
determinant1454732determinant
determinants1553472determinants
determinately1953192determinately
determinative1954072determinative
determinator1554572determinator
determine1249032determin__e
exterminate2054542exterminate
indeterminate1652982indeterminate
terminate11411202__terminate
deaminate12410173d__eaminate
delaminate1347373de_laminate
denominate13167683de_nominate
deteriorate1255093deteriorate
determent121312903determen_t_
determents131010313determen_ts
determinably2053543determinably
determinacies1853193determinacies
determinantal1661903determinantal
determination1657643determination
determinatives2052933determinatives
determinators1653893determinators
determined1455823determin_ed
determiner1345483determin_er
determiners1444643determiners
determines1358433determin_es
determining1545293determining
determinism1654063determinism
determinist1455203determinist
determinists1553703determinists
exterminated2253603exterminated
exterminates2154293exterminates
germinate1248623__germinate
terminated1348163__terminated
terminates12410003__terminates
alternate948114alter__nate
deaerate9314174deaer___ate
deaminase1245384d__eaminase
deaminated1448014d__eaminated
deaminates1349384d__eaminates
decarbonate1654444decarbonate
decemvirate1952154decemvirate
decerebrate1664014decerebrate
decorticate16134634decorticate
decrepitate1693094decrepitate
defeminize2554014defe_minize
deferment151210304defermen_t_
deferments16128584defermen_ts
defibrinate17112984defibrinate
degerming1435754degermin__g
delaminated1545784de_laminated
delaminates1456904de_laminates
denervate1346174dener__vate
denominated15166254de_nominated
denominates14167204de_nominates
deperming1537114depermin__g
depreciate1555074depreci_ate
deracinate1356564de_racinate
derivate12311204d__er_ivate
desalinate1146674de_salinate
detente83313604dete___n_te
detergent11129574detergen_t_
detergents12116664detergen_ts
deterging1237854detergin__g
deteriorated1453464deteriorated
deteriorates1354444deteriorates
determinateness1861844determinateness
determinations1766894determinations
determinedly1952494determinedly
determinisms1753354determinisms
deterministic1862414deterministic
deterrence1345624deterren_ce
deterrent10128944deterren_t_
deterrents11126474deterren_ts
deterring1138624deterrin__g
detersive1346344detersi__ve
detonate9311194det___onate
detoxicate2054484det_oxicate
deuterate1049514deuter___ate
discriminate17164804discriminate
disseminate1485544disseminate
dominate11312854d___ominate
effeminate1852974_effeminate
eliminate1147734_e_liminate
emarginate1385454_emarginate
exterminator2153254exterminator
extermine1848284extermin__e
geminate11411804__ge_minate
germinated1446564__germinated
germinates1347764__germinates
indeterminable1962874indeterminable
indeterminacy2161984indeterminacy
indeterminately21111964indeterminately
inseminate1246674inse_minate
interminable1656894interminable
intermingle1445764intermingle
metricate1349914met_r_icate
peregrinate1454034peregrinate
preterminal1554584pretermina_l
recriminate1555234recriminate
redetermine14103694redetermin__e
renominate12178424re_nominate
staminate1187984_st_aminate
terminable1476604__terminable
terminal1039734__termina_l
terminals1147454__terminals
terminative1656134__terminative
terminator1246634__terminator
termite9313894__termi__te
ternate7415484__ter__nate
turbinate1146674__turbinate
undeterminable1962754undeterminable
ungerminated1653334ungerminated
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.300595636.7
2DLD Change Limit1488191168.81016892.1
3Display Results1161160.0801450.0
 (SQL Overall)1786911169.19019444.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.