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

237 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
orcein83818(None) 
orceins937741orceins
orcin72716571orc_in
crocein1138072crocein
hordein1138752hordein
narcein936292narcein
ocean71212962o_cean
olein5316002o_lein
orchid1289572orchid
orchil1158652orchil
orchis11710772orchis
orcins83313432orc_ins
ordain7810402ordain
origin7311032origin
orpin73415532or_pin
ossein636592ossein
rein46040892_r_ein
urchin1138742urchin
acetin8314693_acetin
actin74922553_actin
arced88224163arce_d
archean1269123archean
archil11611573archil
archine125817053archine
arching136216693arching
archon11311753archon
arcing95819643arc_ing
arcking145811963arcking
arcsine94512393arcsine
arctic10313513arctic
areic73219393ar_eic
arpen74418043arpe_n
arshin9312173arshin
boreen8314313bor_een
brain76229383br_ain
bren65629563br_e_n
brin67038193br__in
bromin102615693bromin
brucin1049133brucin
bruin75818333br_uin
cain65643913__cain
casein83216453casein
ceil65725063__ceil
chin96934743__chin
cocain101315013cocain
cochin131313203cochin
codein94916723codein
coin66645353__coin
conceit113218073conceit
concern113011963concern
corbeil11859213corbeil
coreign1037343cor_eign
cortin82423153cor_tin
cretin82917913cretin
croceine1248033croceine
croceins1238103croceins
cyclin1339273cyclin
deceit93018213deceit
decern91310953decern
devein1039143devein
dormin9312313dor_min
drain65222893dr_ain
dreeing94311183dreeing
dynein1035563dynein
fadein1068843fadein
ficin103516723fic_in
force105324273force__
forced126316523force_d
forceps14466983forceps
forcer114917343force_r
forcers124215713forcers
forces114422133force_s
forcing134013753forc_ing
foreign1136833for_eign
forfeit1339203forfeit
freeing113713913freeing
gorgerin1044963gorgerin
gorhen1038893gorhe_n
gradin83517483gradin
grain65126253gr_ain
gratin74520583gratin
greeing93613783greeing
green65522143gr_een
grin55733723gr__in
groin65521083gr_oin
herein93717793herein
hordeins1238323hordeins
lectin82515013lectin
lomein8410203lomein
lucern846103lucern
lutein6311263lutein
morceau1145573morceau
moreen8313343mor_een
morgen9312203morge_n
morphin1439003morphin
mucin93116823muc_in
murein8311763murein
narceine1046753narceine
narceins1036413narceins
nuclein966123nuclein
oaken95814383oake_n
oaten55222403oate_n
obtain839183obtain
oceans81211003o_ceans
ocrea73311823ocre_a
ocreae83310273ocreae
octan71313483o_ctan
odeon6411483o_deon
often84611413ofte_n
olden65114853olde_n
olefin937583olefin
oleic7313333o_leic
oleine6313793o_leine
oleins6313523o_leins
omen66828183o_me_n
once65423083once__
oncet74626543once_t
open66427003o_pe_n
opsin7613473o_psin
orating83520323orating
oration71617713oration
orbed85516193orbe_d
orbier839993orbier
orbing93312363or_bing
orbit73622063or_bit
orc57034923orc___
orca65522773orc__a
orcas75918623orc_as
orchids1377213orchids
orchils1277703orchils
orcinol944703orc_inol
orcs67025433orc__s
ordains879653ordains
ordeal779253ordeal
order65019363orde_r
ordering1039353ordering
orders74315993orders
ore36661833or_e__
oread64619603or_ead
orectic1138823orectic
oreide7311673or_eide
ores46056683or_e_s
organ6915393or_gan
orgeat7515033orgeat
orgic8311823or_gic
orgies72316093orgies
oribi7311093oribi_
oribis838833oribis
oriel54920423orie_l
oriels64914623oriels
orient6322533orient
origan7310693origan
origins8310463origins
orison6411663orison
orle45630463orle__
orles55326213orle_s
orlon5415003or_lon
ormer75218373orme_r
ormers84316143ormers
ornery938463ornery
ornis54616773or_nis
orphan1137733orphan
orphic1368323orphic
orpine83914483or_pine
orpins83614163or_pins
orrery936783orrery
orris54516553or_ris
oscine8311563osc_ine
osseins736133osseins
ouching134314903ouching
outsin63617563outsin
oven76624143o_ve_n
owsen84210193owse_n
oxen116218593o_xe_n
pectin102615533pectin
pein65834943__pein
porcelain1344133porcelain
porcine11312843porc_ine
porcini1137633porc_ini
porcino1138113porc_ino
precis103416703precis
preeing103817673preeing
preen75925053pr_een
prochein1547523prochein
protein92414733protein
rain46251733_r_ain
ravin85624653_ravin
rawin85521473_rawin
recit75235103_recit
recoin84320293recoin
recon75624243_recon
rei35647253_r_ei_
reif76937653_r_eif
reign65015193_r_eign
reink95518093_r_eink
reins56234563_r_eins
reis45343233_r_eis
renin54830033_renin
repin75324703_repin
resin54131053_resin
rewin85623963_rewin
ricin74620213_ricin
rin36663183_r__in
robbin103611183robbin
robin74820283_robin
rocking143619633rocking
rosin55325313_rosin
rouen54920903roue_n
roven85521973rove_n
rowen84921153rowe_n
ruin47430513_r_uin
rutin55421343_rutin
screen85216013screen
secern81010223secern
serein63318463serein
skein94814413_skein
sorcery1237033sorcery
stein54620543_stein
tamein8313093tamein
thein85919023_thein
tocsin8311003tocsin
torching142510083torching
torchon1237363torchon
torten65314353torte_n
train56529113tr_ain
treeing83414303treeing
treen55622753tr_een
tropin83316753tropin
trueing83410183trueing
uraei53016083uraei_
urchins1238863urchins
ureic74514463ur_eic
vein75625753__vein
worsen95513873worse_n
wren78221683wr_e_n
zechin20137703zechin
zein135620603__zein

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162375.46620621.3
3Display Results2372370.0802962.5
 (SQL Overall)1786912375.68631426.5
 
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.