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

395 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
crocine1131415(None) 
croceine1248031croceine
bromine112915242bromine
brucine1138272brucine
calcine11315272calcine
choline122915382choline
chopine143512262chopine
chorine123218362chorine
cocaine111315172c_ocaine
conine84528552c_onine
corvine122113642corvine
cosine83823512c_osine
crimine112413472crimine
crocein1138072crocein_
croceines1347732croceines
croceins1238102croceins
croci95818132croci__
crocking174313442crocking
crocoite1248052crocoite
crone75231332cro__ne
crowing133814762crowing
phocine1438832phocine
porcine11312842porcine
procaine12312272procaine
proline92321592proline
promine112819442promine
propine113020212propine
tropine93116652tropine
acridine1139553acridine
apocrine1246933apocrine
arcane81216743ar_cane
archine125817053archine
arcing95819643ar_cing
arcsine94512393arcsine
aroint6328153aro_int
arsine64021043ar_sine
atropine10410113atropine
biocide1237323biocide
bovine11712433_bovine
bracing123817613bracing
brine75132273br__ine
brocade1238533brocade
broche133612103broc_he
broking143514823broking
bromide12269583bromide
bromin102615693bromin_
bromines122514253bromines
bromins112513783bromins
bromize20238823bromize
brownie12178433brownie
brucin1049133brucin_
brucines1237763brucines
brucins1158003brucins
calcined1338743calcined
calcines12314753calcines
calcite11413783calcite
calycine1546963calycine
canine83826703c_anine
caprine11314233caprine
carabine12412383carabine
carbine112918643carbine
carline93923613carline
carmine112918483carmine
caroche1469243caroc_he
caroling113317003caroling
caroming133312963caroming
carotene1039133carotene
carotin92216713carotin_
carotins102315583carotins
cassine93817283cassine
cauline92215603cauline
cervine122610803cervine
chaine115119223c_haine
chicane1489553chicane
chine105231723c__hine
chlorine133013303chlorine
chocking204011013chocking
choice132010523cho_ice
choking173911943choking
cholines132214483cholines
chopin132712183chopin_
chopines152711733chopines
chopins142312243chopins
chorines132917253chorines
choring133617663choring
chowing164412773chowing
chromide1648053chromide
chroming163410723chroming
chromite15310833chromite
chromize2447673chromize
cine66242943___cine
citrine92514023citrine
cline76428533c__line
cloche134312373cloc_he
clocking174312413clocking
clone75728163clo__ne
cloning103215473cloning
closing103114843closing
cloying133511753cloying
cocain101315013c_ocain_
cocaines121314443c_ocaines
cocains111313923c_ocains
cochin131313203c_ochin_
cochins141413093c_ochins
cocinera1245553c_ocinera
cocking163619983c_ocking
cockle143913573c_ockle
cockney1835873c_ockney
codeine103815033codeine
coding104024793c_oding
cohune1189423c_ohune
coigne94612193c_oigne
coin66645353c_o_in_
coined94523603c_o_ined
coiner84323783c_o_iner
coins75834553c_o_ins
coking134523883c_oking
colicine12312993colicine
colin76231693c_olin_
colins85229043c_olins
colone85425003c_olone
combine133014713combine
coming114225453c_oming
concise11314473concise
cone67256963c_o__ne
confine12315583confine
coniine9316803coniine
conin76232723c_onin_
conines93827793c_onines
coning94331823c_oning
conins84327233c_onins
cooing94024923c_ooing
cookie123716043cooki_e
cooking143818973cooking
coolie83821603cooli_e
cooling103422573cooling
cooping123918933cooping
cootie84223073cooti_e
coping113927663c_oping
corbie103618203corbi_e
corbina111911443corbina
cording113620823cording
cordite10315253cordite
coring94433963c_oring
corking143018823corking
cornice11612933cornice
corning103720123corning
corrie83621213corri_e
cortin82423143cortin_
cortina91915963cortina
cortins92421313cortins
corvina12229493corvina
cosie74728263c_osi_e
cosines94122673c_osines
coting94629253c_oting
covin105621123c_ovin_
coving124321523c_oving
covins114618063c_ovins
cowing124526323c_owing
coxing164218863c_oxing
coying124021483c_oying
cozie163519123c_ozi_e
cracking174013903cracking
crackle153611253crackle
cracknel1643703cracknel
crane75331603cr__ane
craning103620303craning
craping124018713craping
crating103725203crating
craving134015733craving
crazing193914583crazing
creatine103417413creatine
creche13310763crec_he
cremini11229063cremini
creolise1037863creolise
creolize1947183creolize
creping122913653creping
crescive1545283crescive
cretin82917913cretin_
cretins93216423cretins
crevice1436153crevice
crewing133212623crewing
cricking173412653cricking
crime94822693cr__ime
crimini11258883crimini
criminy14268453criminy
cringe93515483cr__inge
crinite9513633crinite
crinoline1147773crinoline
cripe95521143cr__ipe
croaking153712153croaking
croc85723733croc___
crochet143616663crochet
crock135921993croc__k
crocked164014433crocked
crocket154615673crocket
crocks145118423croc_ks
crocodile1443803crocodile
crocoites1347463crocoites
crocs95722433croc__s
crocus104813173croc_us
crocuses1239023crocuses
crojik1934113croji_k
crojiks2033173crojiks
crones84729243cro__nes
cronies9622503cronies
cronish12310863cronish
crony105918673cro__ny
crooking153611343crooking
croon75522783cro_on_
crooned103813343cro_oned
crooner93714043cro_oner
crooning113112113crooning
croons85418423cro_ons
croppie13278793croppie
cropping153210883cropping
crore74922863cro__re
crosier94116573crosier
crosse85216303cro_sse
crossing112612683crossing
crostini1038293crostini
crostino1038883crostino
croton84415453croton_
crotons93714373crotons
crouching1746383crouching
croupe105114433cro_upe
crouse84619363cro_use
croute84617273cro_ute
crowdie1335903crowdie
crowding15247933crowding
crown105620083cro_wn_
crowned133912423cro_wned
crowner124012593cro_wner
crownet123714113cro_wnet
crowning143510033crowning
crowns115615113cro_wns
croze164719453cro__ze
crozier18369933crozier
crucial1157893crucial
crucian1146283crucian
crucians1245293crucians
cruciate1287313cruciate
crucible1445193crucible
crucifer1543683crucifer
crucify1744063crucify
cruise84314043cr_uise
crying123612283cr_ying
cryolite1347503cryolite
cuisine9310423cuisine
culicine1248343culicine
curarine10610703curarine
cutline92914543cutline
cyanine122911513cyanine
cystine1239333cystine
cytokine1745023cytokine
cytosine1346873cytosine
docile94213123_docile
domine92918253_domine
drone65324983dro__ne
droning93013723droning
droving12379683droving
ecocide1246733ecocide
eocene8311613_eocene
eosine64519413_eosine
ermine8416923er_mine
eroding9314273eroding
erosive1039193erosive
erotize16311653erotize
errhine1036593errhine
exocrine1745993exocrine
fascine12510583fascine
forcing134013753forcing
frocking18309573frocking
glycine1335713glycine
gracile102512603gracile
gracing113216443gracing
gradine93317033gradine
gratine84719193gratine
grecize1935663grecize
groin65521083gro_in_
groined92710813gro_ined
groins73917203gro_ins
groping113313103groping
growing123512473growing
groyne1037213gro_yne
heroine103517483hero_ine
hircine1239143hircine
hyoscine1644183hyoscine
inosine7314273inosine
iodine74618643_iodine
irone55126363iro__ne
ironing82414013ironing
ironize16610373ironize
isocline1047293isocline
isoline7314013isoline
kaoline11310143kaoline
kerosine1238143kerosine
koine9516483_ko_ine
krone94018733kro__ne
leonine7311233leonine
leucine938073leucine
merocrine1346233merocrine
microcline1647063microcline
miocene1147923miocene
moline84422033_moline
moraine9314573moraine
opine77422463__opine
orcin72716573or_cin_
orcins83313433or_cins
oroide7311703oro_ide
orpine83914483or_pine
oscine8311563_oscine
ovine86316643__ovine
piscine11610973piscine
porcini1137633porcini
porcino1138113porcino
praline93019743praline
precipe133012123precipe
precise113518173precise
pricing123417343pricing
primine113214823primine
probing123314443probing
procaines13311513procaines
procure1138573procure
profane122111863profane
profile123211153profile
prolines102619693prolines
promines123018803promines
promise113415843promise
prone75332623pro__ne
propane112716153propane
propene112716043propene
propined133111503propined
propines122618933propines
propone112716303propone
prosing103319383prosing
provide1339853provide
province1546923province
proving134214073proving
pyronine1349513pyronine
racing95030533_racing
rapine85023083_rapine
ratine65131823_ratine
ravine95522223_ravine
recane83022873_recane
recipe103414893_recipe
recite83625113_recite
recline94020493_recline
refine95225693_refine
reline65434353_reline
repine85627813_repine
retine66237333_retine
rexine134719443_rexine
ricin74620213_ricin_
ricing94822763_ricing
ricins83618703_ricins
robin74820273_robin_
robing93617993_robing
robins83617443_robins
rocking143619633_rocking
romaine9512123_romaine
roping94023023_roping
rosin55325313_rosin_
rosined84911903_rosined
rosing73925593_rosing
rosins64521863_rosins
rosiny94414533_rosiny
routine72615903_routine
roving103618743_roving
rowing103623303_rowing
rusine63916593_rusine
serotine8313563serotine
sordine82515223sordine
soricine10710883soricine
sozine15712343_sozine
toxine133114123_toxine
tracing103720153tracing
tricing103417353tricing
trine54734603tr__ine
troche113112513troc_he
trochee122613873trochee
trocking153612423trocking
troking123514103troking
trone55131863tro__ne
tropin83316753tropin_
tropines102214923tropines
tropins93116303tropins
trotline8310023trotline
trowing113413703trowing
trucing103211843trucing
tyrosine1147043tyrosine
uridine81311213uridine
urine55026593ur__ine
ursine64114123ur_sine
vaccine1437323vaccine

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340273957.62617575.0
3Display Results3953950.1562532.1
 (SQL Overall)1786913957.93522519.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.