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

75 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
exterminatory256248(None) 
exterminator2153251exterminator_
exterminators2252961exterminators
determinator1554573determinator_
determinators1653893determinators
exterminate2054543exterminat__e
exterminated2253603exterminat_ed
exterminates2154293exterminat_es
exterminating2373863exterminating
extermination2275743extermination
exterminations2365123exterminations
terminator1246633__terminator_
terminators1346033__terminators
determinately1953194determinately
extenuatory2152464exte__nuatory
alternator1044555alter__nator_
alternators1154105alter__nators
comminatory2055245__comminatory
determinably2053545determina_bly
determinacy1953085determina__cy
determinate1446625determinat__e
determination1657645determination
determinations1766895determinations
determinative1954075determinative
discriminatory2262505discriminatory
eliminator1245125e__liminator_
eliminators1344815e__liminators
excitatory2254345ex___citatory
exclamatory2552115exclam__atory
exhortatory2452205exhor__tatory
expiatory2145185ex___pi_atory
expiratory2244735ex___piratory
explanatory2352605ex__planatory
explicatory2553845ex__plicatory
expurgatory2452295expur__gatory
extenuator1753225exte__nuator_
extenuators1852995exte__nuators
exterior1547395exter_i___or_
exteriorly2083365exter_i___orly
exteriors1647345exter_i___ors
extermine1848285extermin____e
extermined2045325extermin___ed
extermines1947785extermin___es
extermining2154045extermin__ing
externality2155045exter__nality
externally2045545exter__na_lly
exteroceptor2361855exteroceptor_
exteroceptors2461835exteroceptors
extirpator1953275extir__pator_
extirpators2053165extir__pators
extortionary2262695extortiona__ry
extortionately2471535extortionately
extremity2153355extremi__t__y
incriminatory2062885incriminatory
inseminator1354245inse_minator_
inseminators1453765inse_minators
interdictory1853765interdi_ctory
interminably1956435intermina_bly
interrogatory1773645interrogatory
intimidatory1853385int_imidatory
minatory1338555_____minatory
recriminatory2062645recriminatory
terminably1755555__termina_bly
terminally1567025__termina_lly
terminate11411205__terminat__e
terminated1348165__terminat_ed
terminates12410005__terminat_es
terminating1447355__terminating
termination131311165__termination
terminations14149765__terminations
terminative1656135__terminative
terminology1753205__terminology
termitary1444195__termi__tary
territory1245115__terri__tory
veterinary1652865veter_ina__ry

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.436409841.7
2DLD Change Limit124790758.92313985.2
3Display Results75750.0461630.4
 (SQL Overall)178691759.40518999.6
 
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.