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

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

48 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
noninterference2081491noninterference_
interference1756014___interference_
interferences1855474___interferences
interferential1763976___interferential
nonconference2074196no__nconference_
nonindependence21101566nonindependence_
noninfluence1783196nonin___fluence_
noninfluences1882906nonin___fluences
conference1799017co__n___ference_
conferences1898817co__n___ferences
conferrence1896577co__nfer__rence_
conferrences19106077co__nfer__rences
counterforce1985797co_unterfor__ce_
counterforces2085557co_unterfor__ces
indifference2162917___indifference_
indifferences2262817___indifferences
inference14411037___in___ference_
inferences15410357___in___ferences
intemperance1853787___intemperance_
intemperances1953157___intemperances
interdepended1862137___interdepended
interfere12410817___interfer___e_
interfered1448537___interfer___ed
interferer1347737___interfer___er
interferers1446187___interfere__rs
interferes1349987___interfer___es
interfering1558927___interferin__g
interferon1346857___interferon___
interferons1446747___interferon__s
interfertile1556427___interfertile_
interservice1754077___interservice_
misreference1982527__misre_ference_
misreferences20102097__misre_ferences
nonconcurrence1772617nonconcur__rence_
nonconcurrences1872147nonconcur__rences
noninsurance1462777nonin___surance_
nonintegrated1562717noninte__gr_ated
noninteracting1762667noninteractin__g
noninteractive1973027noninter_active_
nonintercourse167917noninter_course_
nonintercourses177697noninter_courses
noninterest1155417nonint___ere__st
nonintersecting1871547noninterse_cting
nonintervention1871497noninterve_ntion
nonoccurrence1672187nonoccur__rence_
nonoccurrences1771927nonoccur__rences
nonperformance23231967no__nperformance_
nonperformances24221807no__nperformances

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 Filter178691950240.360496363.9
2DLD Change Limit95024489.17310359.1
3Display Results48480.0301600.0
 (SQL Overall)178691489.56318685.7
 
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.