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

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

51 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
nonintervention187149(None) 
intervention1568383___intervention
interventions1657514___interventions
nonintersecting1871544nonintersecting
contravention18103875co__ntravention
interception1649395___interception
interjection2198925___interjection
intersection14610185___intersection
nonconservation2063095nonconserv_ation
noninformation1973315noninfor_mation
noninteracting1762665noninter_acting
noninteractive1973025noninter_active
noninterest1155415noninter_est___
conservation1749406co__nserv_ation
consternation15106366con_ster_nation
contention12412226co__nt___ention
contraventions19103576co__ntraventions
convention15410566co__n___vention
counteraction1755386co_unter_action
counterpetition1961946co_unterpetition
counterquestion2671216co_unterquestion
counterreaction19102376co_unterreaction
innervation1447446___innerv_ation
intellection1466176___intellection
intention9412016___int___ention
interaction13411816___inter_action
interceptions1758186___interceptions
intercession14226446___intercession
interdiction1568146___interdiction
interjections2277996___interjections
interrelation1358736___interrelation
interruption1466406___interruption
intersections1598966___intersections
intersession12175816___intersession
interstation12410416___interstation
interunion1046256___inter_un_ion
intervening1548176___interven_ing
intervenor13106066___interven__or
interventionism2062376___interventionism
interventionist1862906___interventionist
invention1248336___in___vention
nonelection1347206no__n_e_lection
nonimportation1862226nonimpor_tation
noninformations2073136noninfor_mations
nonintellectual17131546nonintellectual
noninterference2081496noninterference
reinnervation1653626_reinnerv_ation
reinvention1454516_rein___vention
supervention17105996___supervention
uninteresting1482206_uninter_esting
winterization25137816__winterization

Search took 8 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 Filter178691950240.356501941.0
2DLD Change Limit95024517.25313101.3
3Display Results51510.0301700.0
 (SQL Overall)178691517.63923391.9
 
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.