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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

69 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
complementary2412359(None) 
complimentary24133151complimentary
complemental2054352complementa_l
complementarily2682382complementarily
complementarity2682232complementarity
commentary1945753com___mentary
complement18510103complement___
complementaries2372343complementaries
complemented2154173complement_ed
complementing2253613complementing
complements1948183complement__s
complimentarily2692153complimentarily
nonelementary1862793nonelementary
supplementary2262033supplementary
uncomplimentary26111553uncomplimentary
competently2054824comp_etent_ly
complacently2353234complacent_ly
complementation2392694complementation
complementizer3172224complementizer
complementizers3291624complementizers
compliment1848404compliment___
complimented2153364compliment_ed
complimenting2252864complimenting
compliments1946584compliment__s
couplement1647414couplement___
couplements1756194couplement__s
elementary1553644___elementary
implementer1753414_implementer_
implementers1852724_implementers
implementor1752934_implementor_
implementors1852424_implementors
alimentary1553985___alimentary
clemently1645065c___lement_ly
cometary1547695co____me_tary
commentate16108175com___mentate
commenter151410695com___menter_
commenters16139485com___menters
compartmental2162485compartmenta_l
compensatory2163645comp_ensatory
competency2155045comp_eten__cy
competent15411255comp_etent___
complacency2152505complacen__cy
complacent1846695complacent___
completely1944555compl__e_tely
completeness1854635completen_ess
completer153310415compl__e_ter_
completers16298325compl__e_ters
completest16297875completest___
complexer22316215complexe___r_
complexest23265595complexest___
complexity2653435comple_xit__y
compliantly2053835compl_iant_ly
coparcenary2061385co_parcen_ary
cotyledonary217855cotyledon_ary
coulometry1753765co_ulome_t_ry
documentary1953065do__cumentary
filamentary1952355__filamentary
implement1549535_implement___
implemented1853165_implement_ed
implementing1952705_implementing
implements1647855_implement__s
momentary1645235__m__omentary
pigmentary1852955___pigmentary
semilegendary207815semilegendary
semisedentary19101205semisedentary
supplemental1862305supplementa_l
supplementals1961965supplementals
supplementer18122505supplementer_
supplementers19121895supplementers

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 Filter1786911247900.390458182.1
2DLD Change Limit124790698.70614333.8
3Display Results69690.0461500.0
 (SQL Overall)178691699.14219546.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.