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

91 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
correcting1519930(None) 
coerecting15218781coerecting
cocreating15310292cocreating
codirecting1743642codirecting
collecting1548282collecting
confecting18310552confecting
connecting15310382connecting
convecting18310432convecting
correction1448812correction
corrections1548872corrections
corrective1747442corrective
correlating1487082correlating
corrupting1555582corrupting
corseting12312172corse_ting
arresting1038633_arresting
carpeting1439483carpe_ting
cathecting1844833cathecting
coacting133412703co__acting
coenacting1545873coenacting
coercing1349003coer_c_ing
coexerting2045493coexerting
coinfecting1944573coinfecting
colleting12311063colle_ting
commenting1749173commenting
compacting19177093compacting
competing163712463compe_ting
complecting2045763complecting
conceiting15311773conceiting
concerting15313893concerting
concocting1448413concocting
concreting1539873concre_ting
conducting1648833conducting
congesting14410113congesting
consenting13313223consenting
contacting15610073contacting
contenting13313323contenting
contesting13312213contesting
contracting16610473contracting
conventing16311543conventing
converting16313133converting
convicting1847583convicting
coparenting1644613coparenting
coquetting2244513coquetting
corbeling1439033corbe_ling
corbelling1546713corbelling
cordelling1446383cordelling
corelating13511583corelating
cornering12311893corne_ring
cornicing1439043cornic_ing
coronating13410173coronating
corotating1349323corotating
corrading1338203corr_ading
corralling1345433corralling
correct11513983correct___
corrected1438123correct_ed
correcter1348113correct_er
correctest1445613correctest
correctional1675323correctional
correctives1845573correctives
correctly1644963correct_ly
corrector1347603correct_or
correctors1447503correctors
corrects1259573correct__s
corroding1337943corr_oding
corrugating1544263corrugating
coruscating1644693coruscating
cosseting1239543cosse_ting
courting112514573cour__ting
coveting141912313co_ve_ting
cowriting1557323cowr_iting
creating113921953c__reating
cresting114017043c__resting
curetting1236573c_uretting
curveting1535353curve_ting
curvetting1643393curvetting
directing1338823_directing
erecting112415063__erecting
ferreting13127703ferre_ting
foresting13311363fo_resting
forfeiting1744133forfeiting
forgetting1544663forgetting
objecting2144053_objecting
orienting1038723_orienting
perfecting1847513perfecting
projecting22177243projecting
prosecting15189813prosecting
protecting151910213protecting
reerecting1339973reerecting
tormenting1345693tormenting
torrefying1742853torrefying
worriting1345553worr_iting

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 Filter1786911406030.423422437.4
2DLD Change Limit140603917.58018549.2
3Display Results91910.0432116.3
 (SQL Overall)178691918.04622208.7
 
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.