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

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

92 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
excreting194643(None) 
accreting1446332accreting
exceeding2043492exceeding
excepting2145872excepting
excerpting2244142excerpting
exciting1838022exc_iting
excretion1846712excretion
excretions1946622excretions
excretive2145142excretive
execrating2047882execrating
exerting162211152exer_ting
experting1938052experting
exserting1736662exserting
secreting1279822secreting
bucketing1835713bucketing
cacheting1737153cacheting
cocreating15310293cocreating
concreting1539873concreting
crating103725203__crating
creating113921953__creating
creping122913653__creping
cresting114017043__cresting
cretin82917913__cretin_
cretins93216423__cretins
crewing133212633__crewing
decreeing1335523decreeing
docketing1785413docketing
embruting1444283embruting
emceeing1343573emc_eeing
encrusting13125293encrusting
encrypting1843053encrypting
encysting1544613encysting
entreating11811553entreating
erecting112415063e__recting
escheating1645883escheating
eschewing1893503eschewing
escorting1237713escorting
escoting1158713esc_oting
escrowing1544813escrowing
estreating11710363estreating
everting122213133ever_ting
exacting1838523ex_acting
exalting1638033ex_alting
excavating2344113excavating
excelling1935643excelling
excessing1945713excessing
exciding1935923exc_iding
excising1837213exc_ising
excluding2043463excluding
excoriating2145483excoriating
excrement2048063excrement
excreta1674623excret__a
excretal1764353excret_al
excrete1667163excret__e
excreted1846153excret_ed
excreter1766123excret_er
excreters1874873excreters
excretes1787573excret_es
excretory2143463excretory
excusing1836503exc_using
executing1945583executing
exempting2144223exempting
exhorting2045733exhorting
existing1639073ex_isting
exiting15311393ex__iting
expecting2146693expecting
expiating1938543expiating
exporting1937323exporting
expressing2046623expressing
exsecting1935933exsecting
extorting1746763extorting
extracting2047223extracting
extruding1844333extruding
exulting1637643ex_ulting
faceting1438783fac_eting
ferreting13127693ferreting
jacketing2345643jacketing
packeting1836853packeting
picketing1835683picketing
pocketing1875853pocketing
racheting1537793racheting
racketing1647873racketing
recrating121318793recrating
recreating131214583recreating
rocketing1666973rocketing
screwing14288233_screwing
secretin10108343secretin_
secretins11108463secretins
socketing1666383socketing
ticketing1635633ticketing
uncrating12813183uncrating
uncreating13310473uncreating

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 Filter1786911486410.406440125.6
2DLD Change Limit148641927.48619855.9
3Display Results92920.0462000.0
 (SQL Overall)178691927.93822510.8
 
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.