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

111 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
supplicates174413(None) 
supplicate1644521supplicate_
supplicated1843731supplicated
duplicates1546632du_plicates
supplicants1752412supplicants
auspicates1444913ausp_icates
complicates1947053complicates
duplicate1447003du_plicate_
duplicated1655833du_plicated
explicates2196663_explicates
implicates1646783_implicates
replicates1449453_replicates
silicates11311523s__ilicates
spoliates1138543s_poli_ates
sublimates1447173su_blimates
subprimates1753463subprimates
supinates1139553su_p_inates
suppliances17102663suppliances
suppliants1443303suppli_ants
supplicant1653683supplica_nt
supplicating1953743supplicating
supplication1855393supplication
supplications1954913supplications
supplicatory2181903supplicatory
supplies1268833suppli___es
suppurates1445043supp_urates
suricates11311743su__ricates
surplices1346043surplic__es
triplicates1544803triplicates
applicants1653624_applicants
applicator1645104_applicator
applicators1744254_applicators
auspicate1345744ausp_icate_
auspicated1544304ausp_icated
busticates1456614bu_sticates
complicate1847624complicate_
complicated2046094complicated
delicates12314314__delicates
duplicator1544804du_plicator
duplicators1644294du_plicators
duplicities1645334du_plicities
explicate20117494_explicate_
explicated22106104_explicated
humiliates1544624humili_ates
implicate1547274_implicate_
implicated1745974_implicated
lubricates1446054lu_bricates
oppilates1345454_opp_ilates
placates12311754___placates
plicate11314514___plicate_
plicated13310644___plicated
reduplicates1753814reduplicates
replicases1444674_replicases
replicate13410044_replicate_
replicated1548774_replicated
rubricates1445894ru_bricates
rusticates1248054ru_sticates
salivates1239294s__alivates
sextuplicates2471744sextuplicates
silicate10312624s__ilicate_
simplices1546044simplic__es
simplicities1864144simplicities
sonicates11410384s__onicates
speciates13229234s_peci_ates
spicate113214194s__p_icate_
spicated13309904s__p_icated
splices113914384s__plic__es
spoliate1039244s_poli_ate_
spoliated1246914s_poli_ated
subclimaxes2451544subclimaxes
sublates10315004su_bl__ates
sublimate1347444su_blimate_
sublimated1545874su_blimated
subprimate1643644subprimate_
succinates1445634su_ccinates
sufflates1546034suffl__ates
suffocates1843254su_ffocates
sulcate9314424su__l_cate_
sulcated11310374su__l_cated
sulfates11310794su__l_fates
sulphates1466164su__lphates
sulphites1445684sulphi__tes
supernates12413264su_pernates
superstates1349554superstates
supinate10310314su_p_inate_
supinated1237884su_p_inated
supplanted15113504suppl_anted
supplanter14113674suppl_anter
supplanters15113044suppl_anters
supplants1344874suppl__ants
supplejacks2851494supplejacks
supples11511284suppl____es
suppliance1692834suppli_ance
suppliant1345184suppli_a_nt
suppliantly1852164suppliantly
supplied1345994suppli___ed
supplier1246604suppli___er
suppliers1354484suppli__ers
suppurate1345434supp_urate_
suppurated1544094supp_urated
suricate10312614su__ricate_
surplice1246204surplic__e_
surpliced1444154surplic__ed
surplusages1451024surplusages
syndicates1644474s_yndicates
triplicate1445324triplicate_
triplicated1653934triplicated
tunicates11268744tu__nicates
uppercases1643424_uppercases
urticates1148894_u_rticates
vellicates1545904_vellicates

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191118.34317837.6
3Display Results1111110.0631761.9
 (SQL Overall)1786911118.82920239.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.