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

72 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
disinfested165372(None) 
disinfected1853671disinfected
disinvested1653471disinvested
disinfest1346902disinfest__
disinfests1443882disinfest_s
disaffected21172553disaffected
disinfect1545043disinfect__
disinfects1653653disinfect_s
disinfestant1673223disinfestant
disinfesting1754433disinfesting
disinformed1853013disinformed
disinherited1753413disinherited
disinterested1562133disinterested
disinterred1353933disinterred
disinvest1346803disinvest__
disinvests1443763disinvest_s
disinvited1544393disin_vited
infested12249643___infested
misinferred1752493misinferred
noninfested1552663noninfested
coinfected1843824_coinfected
decongested1663074decongested
delineated1246244delin_eated
desisted1039784desi___sted
digested11208164d__i_gested
diminished1744104dimin_ished
dipnetted1343354di_pn_etted
discepted1547524dis__cepted
disconcerted1854344disconcerted
disconnected1853714disconnected
discontented1655314discontented
disgusted1246124dis__gusted
disinclined1553524disinclined
disinfectant1873454disinfectant
disinfecting1954694disinfecting
disinfection1855104disinfection
disinfestants1772484disinfestants
disinhibited1962294disinhibited
disintegrated1662834disintegrated
disinter9310674disin___ter
disinvesting1754204disinvesting
disinvestment1963474disinvestment
disinvite1345434disin_vite_
disinvites1445154disin_vites
disjected2086354dis__jected
dismasted1346834dis__masted
disoriented1355264disoriented
disquieted2144004disquie_ted
disseated11711084dis__seated
dissected13108664dis__sected
dissented1199724dis__sented
disserted11109814dis__serted
distasted1137964dis__tasted
distressed1246444dis_tressed
distrusted1246294dis_trusted
disunited1177274disun__ited
ditsinesses12108764ditsin_esses
divested13268214d__i_vested
divinest123012174divin_est__
divinised1465474divin_is_ed
infected14229404___infected
infester11239434___infester
ingested10259004___ingested
invested12229694___invested
ironfisted1442164_ironfisted
manifested1642974mani_fested
misinformed1952324misinformed
misinterred1453354misinterred
noninfected1752964noninfected
reinfected1645254_reinfected
reinvested1444794_reinvested
uninfected1663694_uninfected

Search took 9 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.470380193.6
2DLD Change Limit148819728.23318075.9
3Display Results72720.0461565.2
 (SQL Overall)178691728.74920424.2
 
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.