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 “coreigns” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

149 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
coreigns113632(None) 
coreign1037341coreign_
codeins103715482codei_ns
codesigns1353662codesigns
coigns94410062co__igns
consigns1137532consigns
cordings123011352cordings
cortins92421332corti_ns
cosigns1047512co_signs
foreign1136832foreign_
reigns74811752__reigns
arraigns944353arraigns
boreens9310403bore_ens
borings103614243bor_ings
cardigans1345153cardigans
cardings123812633cardings
careens94514703care_ens
carlings114015853carlings
carlins93921913carli_ns
carpings133812383carpings
carrions10312453carrions
carvings143810203carvings
caseins93115053casei_ns
choregus1484213chore_gus
chorions13310653chor_ions
coamings13349293coamings
coatings113811843coatings
cocains111313923cocai_ns
cochins141413103cochi_ns
codeias103911223codei_as
codein94916723codei_n_
codeina104010323codei_na
codeinas11338023codeinas
codeine103815033codei_ne
codeines113114523codeines
codens94821013code__ns
codesign1274503codesign_
codlings123110103codlings
codlins104116243codli_ns
coercions1346203coercions
coffins153110193coffi_ns
coheirs1236753cohei_rs
cohesions1447093cohesions
coign85013913co__ign_
coigne94612193co__igne
coignes103912153co__ignes
coins75834553co__i_ns
coitions10312853coitions
cojoins1638993cojoi_ns
colins85229043co_li_ns
collins93419833colli_ns
combings15348323combings
comedians1445823comedians
comings124013533co_mings
condign1147733condign_
conins84327233co_ni_ns
consign1038773consign_
cookings15358603cookings
copens106119963cope__ns
copings124111843co_pings
corbans11313173cor_bans
corbeils12358073corbei_ls
corbelings1544073corbelings
corbies113520123corbi_es
corbina111911453corbi_na
corbinas12229393corbinas
cordages12310113cordages
cordials1139623cordials
cording113620823cordi_ng
cordites11314623cordites
cordons104415763cor_dons
coreless103013833coreless
corers85231073core__rs
cores76361853core___s
corgis9314413cor__gis
coring94433963cor_i_ng
corkages1539103corkages
corking143018823corki_ng
corneitis1146493corneitis
cornelians1244533cornelians
cornices12713293cornices
corning103720123corni_ng
corns76034763cor___ns
corridas1177313corridas
corries94026793corri_es
corsages11310363corsages
corteges1198813corteges
cortices12615013cortices
cortin82423153corti_n_
cortina91915973corti_na
cortinas102212443cortinas
corvids1337683corvi_ds
corvina12229503corvi_na
corvinas13238013corvinas
corvine122113643corvi_ne
cosign958783co_sign_
coursings12235873coursings
cousins9516003cousi_ns
covens114919263cove__ns
coverings15217893coverings
covings134511243co_vings
covins114618063co_vi_ns
cowlings14359773cowlings
cozens176314923coze__ns
crepons1139313c_repons
cretins93216423c_retins
croceins1238103crocei_ns
curbings13407313curbings
curlings114110383curlings
deigns8389983__deigns
deraigns1034883deraigns
dormins10311273dormi_ns
feigns10407753__feigns
foreigner1344663foreigner
foreigners1444143foreigners
foreignism1652513foreignism
foreruns1146623foreruns
forewings1645113forewings
forgings13287703forgings
greiges937733_greiges
hordeins1238323hordei_ns
hornings12238363hornings
lomeins969473lomei_ns
lordings10368503lordings
moreens939963more_ens
morions94014643mor_ions
mornings11297923mornings
morrions1077673morrions
mureins9310733murei_ns
oleins6313523_olei_ns
orceins937743_orcei_ns
orcins83313433_orci_ns
oreides8312023_oreides
origans839973_or_igans
origins8310463_or_igins
orpins83614163_orpi_ns
pereions10310853pereions
portions10514403portions
reign65015193__reign_
reins56234563__rei_ns
resigns83910963__resigns
scorpions1344213scorpions
sereins73716113serei_ns
skreighs16203153skreighs
sorings83817253sor_ings
sovereigns1442133sovereigns
torsions839183torsions
wordings13328563wordings
workings16337503workings

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 Filter1786911461620.313570897.8
2DLD Change Limit1461621497.92318447.8
3Display Results1491490.0632365.1
 (SQL Overall)1786911498.29921531.6
 
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.