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

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
disinfesting175443(None) 
disinfecting1954691disinfecting
disinvesting1754201disinvesting
disinfestant1673222disinfestant
disaffecting2252933disaffecting
disinfectant1873453disinfectant
disinfection1855103disinfection
disinfections1954883disinfections
disinfest1346903disinfest___
disinfestants1772483disinfestants
disinfested1653723disinfest_ed
disinfests1443883disinfest__s
disinforming1953553disinforming
disinheriting1853473disinheriting
disinteresting1662623disinteresting
disinterring1454203disinterring
disinviting1664703disin_viting
infesting13109513___infesting
misinferring1852713misinferring
coinfecting1944574_coinfecting
decongesting1753734decongesting
delineating1346374delin_eating
desisting112810384desi___sting
digesting12208674d__i_gesting
diminishing1853254dimin_ishing
dipnetting1453624di_pn_etting
discepting1658474dis__cepting
disconcerting1954574disconcerting
disconnecting1953884disconnecting
discontenting1755074discontenting
disgusting1345964dis__gusting
disincentive1853394disincentive
disinclining1653274disinclining
disinfect1545044disinfect___
disinfectants1972374disinfectants
disinfected1853674disinfect_ed
disinfects1653654disinfect__s
disinfestation18113614disinfestation
disinfestations1993504disinfestations
disinflation1656584disinflation
disinflations1756294disinflations
disinhibiting2062494disinhibiting
disintegrating1763304disintegrating
disinvest1346804disinvest___
disinvested1653474disinvest_ed
disinvestment1963464disinvestment
disinvests1443764disinvest__s
disjecting2177244dis__jecting
dismasting1446384dis__masting
disorienting14155654disorienting
disquieting2244304disquie_ting
disseating121111784dis__seating
dissecting14139474dis__secting
dissenting121310294dis__senting
disserting121310854dis__serting
distasting1248024dis__tasting
distressing1385974dis_tressing
distrusting1386494dis_trusting
disuniting1247404disun__iting
divesting14298484d__i_vesting
divinising1545104divin_is_ing
infecting15109674___infecting
ingesting11129624___ingesting
investing13119394___investing
manifesting1762734mani_festing
misinforming2052694misinforming
misinterring1553504misinterring
reinfecting1745154_reinfecting
reinvesting1545324_reinvesting

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 Filter1786911247900.1431249587.4
2DLD Change Limit124790697.11017551.3
3Display Results69690.0302300.0
 (SQL Overall)178691697.28324535.4
 
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.