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

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
coprince144709(None) 
coprinces1547481coprinces
caprice1349682capri_ce
caprine11314232caprin_e
convince1547362convince
coppice1537482coppi_ce
cornice11612932co_rnice
prince104114762__prince
capric12411803capri_c_
capricci1342653capricci
caprices1439893capri_ces
capriole1276913capriole
carinae94318583c_arinae
chopine143512263chop_in_e
chorine123218363chorin_e
citrine92514023citrin_e
clarence1246453clarence
cocaine111315173cocain_e
codeine103815033codein_e
codpiece1544063codpiece
codrive1337653codri_ve
coerce10310403coer__ce
coherence1676943coherence
combine133014723combin_e
commence16149103commence
compliance1844933compliance
complice1639333compli_ce
compline14313553complin_e
comprise14310813compri_se
comprize2368733compri_ze
confine12315583confin_e
coniine9316803coniin_e
conine84528553co_nin_e
continue10311123continue
convinced1745363convinced
convincer1645833convincer
convinces1647833convinces
copihue1444143cop_ihue
coping113927663cop_in_g
copings124111843cop_ings
coppiced1734823coppi_ced
coppices1638243coppi_ces
copping143918593coppin_g
coproduce1643543coproduce
copying153411983copyin_g
coring94433963co_rin_g
corniced1368593co_rniced
cornices12713293co_rnices
corniche1575923co_rniche
cornicle1258783co_rnicle
coronae94214893co_ronae
corrie83621223corri__e
corvine122113643corvin_e
cosine83823513co_sin_e
courante1049953courante
covariance1753943covariance
cowrie113814283cowri__e
cowrite123612683cowri_te
cringe93515483c__ringe
cupric1249123cupri_c_
cuprite1159683cupri_te
cyprinid1644173cyprinid
dourine8311453dourin_e
opine77422463_op_in_e
orpine83914483_orpin_e
orrice81410163_orri_ce
prance104318573__prance
price93725413__pri_ce
princes113015143__princes
reprice113212833repri_ce
springe103913983_springe
topline92313183toplin_e

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 Filter1786911461620.406440125.6
2DLD Change Limit146162726.84321359.3
3Display Results72720.0302400.0
 (SQL Overall)178691727.27924548.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.