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

80 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
coerecting1521878(None) 
correcting15199291correcting
cocreating15310292cocreating
codirecting1743632codirecting
coenacting1545862coenacting
coercing1349002coer_c_ing
coexerting2045492coexerting
collecting1548282collecting
confecting18310552confecting
connecting15310372connecting
convecting18310432convecting
erecting112415062__erecting
reerecting1339972reerecting
cathecting1844833cathecting
cementing1438763c_ementing
coacting133412693co__acting
coediting1338323coe_diting
coempting1636073coe_mpting
coequating2245313coequating
coerect11913353coerect___
coerected1447643coerect_ed
coerects1258543coerect__s
coexisting2044403coexisting
coinfecting1944573coinfecting
colleting12311053colle_ting
commenting1749153commenting
compacting19177073compacting
competing163712463compe_ting
complecting2045743complecting
conceiting15311773conceiting
concerting15313893concerting
concocting1448413concocting
concreting1539873concre_ting
conducting1648803conducting
congesting14410113congesting
consenting13313213consenting
contacting15610063contacting
contenting13313323contenting
contesting13312213contesting
contracting16610463contracting
conventing16311543conventing
converting16313133converting
convicting1847573convicting
coparenting1644613coparenting
coquetting2244513coquetting
corelating13511583corelating
correction1448793correction
corrections1548833corrections
corrective1747443corrective
correlating1487073correlating
corrupting1555573corrupting
corseting12312173co_rseting
cosseting1239543cosse_ting
courting112514563cour__ting
coveting141912303co_ve_ting
cowriting1557323cowr_iting
creating113921953c__reating
cresting114017043c__resting
curetting1236573c_uretting
defecting162510223_defecting
dejecting20217793_dejecting
detecting13259983_detecting
directing1338813_directing
ejecting18268163__ejecting
electing112113783__electing
eructing112110173__eructing
foresting13311363fo_resting
objecting2144053_objecting
overacting16310913overacting
overeating141016523overeating
perfecting1847513_perfecting
preerecting1646143preerecting
prelecting15310163prelecting
reejecting2045813reejecting
reelecting1338783reelecting
refecting152413353_refecting
rejecting192211153_rejecting
rerenting102617663_rerenting
resecting122816483_resecting
selecting12310533_selecting

Search took 10 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.343520965.0
2DLD Change Limit140603808.98615646.9
3Display Results80800.0601333.3
 (SQL Overall)178691809.38919032.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.