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

58 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
disinfestation1811361(None) 
disinfestations1993501disinfestations
disinfection1855103disinfe__ction
disinflation1656583disinf__lation
disinformation2063333disinformation
disintegration16123783disintegration
infestation1447043___infestation
reinfestation1664253_reinfestation
disinclination1763964disinclination
disinfections1954884disinfe__ctions
disinfestant1673224disinfesta__nt
disinfestants1772484disinfesta_nts
disinfesting1754434disinfes__ting
disinflations1756294disinf__lations
disinformations2173304disinformations
disintegrations17153634disintegrations
disorientation1583774disorientation
dissertation1366094dis__sertation
infestations1546624___infestations
manifestation1871994mani_festation
misinformation2172594misinformation
reinfestations1793884_reinfestations
contestation1448665__contestation
defenestration18173545defen_estration
deforestation1754305d_eforestation
delineation1247765delin_e__ation
depigmentation20103045depigmentation
desideration1456395desi_de_ration
detestation1248365d___etestation
disaffection2153205disaffe__ction
disaffiliation2163335disaffiliation
disinclinations1863585disinclinations
disinfectant1873455disinfecta__nt
disinfectants1972375disinfecta_nts
disinfecting1954695disinfe__cting
disinfest1346905disinfes__t___
disinfested1653725disinfes__t_ed
disinfests1443885disinfes__t__s
disinhibition1962615disin_hibition
disintegrating1763305disintegrating
disintegrative1962025disintegrative
disintegrator1582055disintegrat_or
disintoxication2572555disintoxication
disinvesting1754205disinves__ting
disorientations1683625disorientations
dispensation1555605dis__pensation
disputation14116745dis___putation
disrelation1248815dis__re_lation
dissertations1465895dis__sertations
divination14139235divin____ation
indentation1248375___indentation
interstation12410415___interstation
itineration1156325_itin_e_ration
manifestations1981865mani_festations
misinformations2282585misinformations
misorientation1693185misorientation
subinfeudation20121465subinfeudation
visitation1348595visi____tation

Search took 7 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 Limit95024586.46614695.9
3Display Results58580.0331757.6
 (SQL Overall)178691586.85926052.0
 
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.