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

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

44 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
noninfested155266(None) 
noninfected1752961noninfected
coinfected1843823co_infected
disinfested1653723disinfested
infested12249643___infested
manifested1642973mani_fested
nonvested1346003no__nvested
uninfected1663693_uninfected
boninesses121111454bonin_esses
bonneted1136224bon_n_e_ted
coinferred1643894co_inferred
coinvented1643994co_invented
confected1739074co__nfected
confessed1546054co__nfessed
congested1338674co__ngested
connected1438754con_n_ected
contested12310704co__ntested
disinfected1853674disinfected
disinvested1653474disinvested
infected14229404___infected
infester11239434___infester
ingested10259004___ingested
invested12229694___invested
manifester1543134mani_fester
manifestoed1751514mani_festoed
nominated1239284nomin__ated
nondirected1552954nondirected
nonelected1355694non_elected
nonindustry1561564nonindustry
noninert8415024nonin_ert__
noninfective2054584noninfective
noninsect1145494noninsect__
noninsects1253664noninsect_s
noninsured1153274nonin_sured
nonintegrated1562714nonintegrated
noninvolved1861444noninvolved
nonselected1454384nonselected
nosinesses101411324nosin_esses
reinfected1645254_reinfected
reinvested1444794_reinvested
sonneted936184son_n_e_ted
sonnetted1044544son_n_etted
uninflated1474764_uninflated
uninflected17112684_uninflected

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 Filter1786911488190.423422437.4
2DLD Change Limit148819448.58017344.9
3Display Results44440.0301466.7
 (SQL Overall)178691449.03319782.0
 
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.