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

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
coparents134797(None) 
coparent12412251coparent_
coagents1138442co_agents
coparented1544852coparented
copayments1944312copayments
godparents1451972godparents
nonparents1246062nonparents
parents93418122__parents
apparent1248263apparent_
cabarets12268463cabare_ts
carets85330773c__are_ts
carnets93918403c__arnets
cigarets1145463cigare_ts
clarets94111103c_lare_ts
coagent10313973co_agent_
coarsens10348123co_arsen_s
codirects1493593codirects
coerects1258543co_erects
coffrets1645363coffre_ts
coherent13412473coherent_
coinvents1445663coinvents
collarets11327333collare_ts
colorants1149863colorants
comments142913873co_mments
comparers15319383compare_rs
compares143816433compare__s
compartments2094333compartments
comparts144210833compar__ts
components1646943components
concents122516603co_ncents
confronts1447063confronts
consents102715893co_nsents
contents104018213co_ntents
convents132614603co_nvents
coparcener1652643coparcener
coparceners1752343coparceners
coparenting1644613coparenting
copartner1343563copartner
copartners1443573copartners
copatrons1346333copatron_s
copayment1845893copayment_
copens106119963cop__en_s
copresents1446453copresents
copylefts1941973copylefts
copyreads1743323copyreads
cornets94820573co__rnets
corrects1259573co_rrects
cotangents1344163cotangents
courants10310803co_urants
covalent1349223covalent_
currents1038373c_urrents
dopants1038433dopa__nts
godparent1353093godparent_
nonparent1148663nonparent_
operants1039483_operants
parent83230423__parent_
patents94815203__patents
torrents838143to_rrents

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 Filter1786911486410.1701051123.5
2DLD Change Limit148641589.28316012.2
3Display Results58580.0301933.3
 (SQL Overall)178691589.48318843.3
 
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.