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

71 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
coprinces154748(None) 
coprince1447091coprince_
caprices1439892capri_ces
convinces1647832convinces
coppices1638242coppi_ces
cornices12713302co_rnices
princes113015152__princes
caprice1349683capri_ce_
caprine11314233caprin_e_
caprioles1376753caprioles
carices114220953c_ari_ces
chopines152711733chop_in_es
chorines132917253chorin_es
citrines102513133citrin_es
clarences1346453clarences
cocaines121314443cocain_es
codeines113114523codein_es
codices12512583co_di_ces
codpieces1643803codpieces
codrives1437663codri_ves
coerces11311943coer__ces
coherences1787043coherences
collinses1138283collinses
combines142814623combin_es
commences17139583commences
compliances1945033compliances
complices1739253compli_ces
complines15312833complin_es
comprises15510943compri_ses
comprizes2468943compri_zes
confines13315653confin_es
coniines10415363coniin_es
conines93827793co_nin_es
continues11310993continues
convince1547363convince_
convinced1745363convinced
convincer1645833convincer
convincers1745063convincers
copies104130313cop_i__es
copihues1543993cop_ihues
copings124111843cop_in_gs
coppice1537483coppi_ce_
coppiced1734833coppi_ced
coproduces1763723coproduces
copurifies1754363copurifies
cornice11612933co_rnice_
corniced1368603co_rniced
corniches1666683co_rniches
cornicles1368253co_rnicles
corries94026803corri__es
cortices12615023co_rtices
cosines94122673co_sin_es
courantes1148883courantes
covariances1853733covariances
cowries124218013cowri__es
cowrites133011593cowri_tes
cringes103215503c__ringes
cuprites1259023cupri_tes
cyprinids1742643cyprinids
dourines9311373dourin_es
fornices1369103fo_rnices
opines84820703_op_in_es
orpines94414793_orpin_es
orrices9129363_orri_ces
prances113618783__prances
prices104524543__pri_ces
prince104114763__prince_
princess12266813__princess
reprices122913353repri_ces
springes114014033_springes
toplines102412563toplin_es

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.423422437.4
2DLD Change Limit148641717.40620070.3
3Display Results71710.0302366.7
 (SQL Overall)178691717.85922737.1
 
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.