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

268 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
cassene9311154(None) 
cassena9287841cassena
cassenes103611291cassenes
cassine93817281cassine
assent65119952_assent
caserne93710062caserne
cassenas10317482cassenas
cassette1047812cassette
cassina94113162cassina
cassines103116612cassines
cassino93512432cassino
passee84522022passe_e
absence1137703_absence
absent84016993_absent
achene11313813_achene
agene65621583_a_gene
akene95818663_a_kene
alkene104114003_alkene
arene55329413_a_rene
arseno6318913_arseno
arsine64021043_arsine
ascend9429733_ascend
ascent84519653_ascent
ashen87818673_ashen_
aspen75216093_aspen_
aspens85013353_aspens
assented957513_assented
assenter867703_assenter
assents74512223_assents
assert64922583_assert
asses55629283_asse_s
assess65710463_assess
asset55932263_asse_t
assets65617663_assets
assize1538633_assize
assume897563_assume
assure6610773_assure
basses85428303basse_s
basset85225383basse_t
basseted1136743basseted
bassets96414823bassets
bassett94213863bassett
bassinet10312843bassinet
cabmen123610653cabmen_
cadence1239063ca_dence
cadent94120363ca_dent
caffeine1644513caffeine
caisson936593caisson_
caissons1036283caissons
calcine11315273calcine
callee84327293calle_e
calzone1848623calzone
camphene1746613camphene
candent10417363candent
cane66653123ca___ne
canine83826703ca_nine
canteen9411083canteen
canzone1858813canzone
caprine11314233caprine
capsize2037623capsize
capstone1237653capstone
capsule1137343capsule
carbine112918643carbine
careen84119493careen_
careened1139193careened
careener1039323careener
careens94514703careens
carline93923613carline
carmen104019343carmen_
carmine112918483carmine
carotene1039133carotene
carse74934333cars__e
carses85233653carse_s
carven114716663carven_
cascade12118603cascade
case65848083ca_s__e
casease939323casease
caseate9314783caseate
cased86032413ca_se_d
casefy1436273ca_sefy
caseic103212373ca_seic
casein83216453ca_sein
caseins93115053caseins
casement12311953casement
caseose939163caseose
casern84713313ca_sern
casernes103810753casernes
caserns94711223caserns
cases75048383ca_se_s
casette9310393casette
cashed125124353cashe_d
cashes114729883cashe_s
cashew144311453cashe_w
cashews15428603cashews
cashing135022553cashing
cashmere1564323cashmere
casimere1254793casimere
casing94829103ca_sing
casini84615863ca_sini
casino84317553ca_sino
casked134815513caske_d
casket124820993caske_t
casketed1534953casketed
caskets133910173caskets
casking144317353casking
casque17299273ca_sque
cassaba1145663cassaba
cassata938143cassata
cassava1255003cassava
casserole1144403casserole
cassettes1146703cassettes
cassia83714763cass_ia
cassias93514343cassias
cassimere1343703cassimere
cassinas103610633cassinas
cassingle1244103cassingle
cassinos10309353cassinos
cassis84818853cass_is
cassises103811743cassises
cassock1545953cassock
castanet10416193castanet
caste75932363ca_s_te
caster85232573caste_r
casters94729903casters
castes85631863caste_s
casting104628343casting
castle84918963ca_stle
catena8312483ca_tena
catenae9311373ca_tenae
cauline92215603cauline
cause75225353caus__e
caused95117043cause_d
causer84117783cause_r
causerie1078273causerie
causers94014793causers
causes88026473cause_s
causey113513273cause_y
causeys12387223causeys
causing103614413causing
cayenne1244603cayenne
cessed94615613cesse_d
cesses84221363cesse_s
cessing103814813cessing
chasse115114603chass__e
chassed134712133chasse_d
chasseing1554963chasseing
chasses124017503chasse_s
chasseur1343443chasseur
chasten124312403chasten_
chastened1545883chastened
chastener1445703chastener
chastens13429183chastens
chosen116014133chosen_
classed104113653classe_d
classer93614613classe_r
classers104111833classers
classes94717943classe_s
classing113211793classing
classon937693classon_
classons1037703classons
coarsen93210323coarsen_
coarsened1245143coarsened
coarsens10348123coarsens
coassume12103973coassume
consent93723113consent
convene123314323convene
cosine83823513c_osine
cosset84125863cosse_t
cosseted1178343cosseted
cossets95014283cossets
crasser94114333crasse_r
crassest103411523crassest
cuisine9310423cuisine
cussed94917123cusse_d
cusser86016093cusse_r
cussers94213403cussers
cusses84522773cusse_s
cussing103814273cussing
cymene1377393c_ymene
cysteine1345333cysteine
cystine1239333cystine
dapsone1038463dapsone
dasheen1136393dasheen
dassie74615573dass_ie
dissent84018683dissent
essence947673_essence
fascine12510583fascine
fasten95114893fasten_
fastened12257853fastened
fastener11227833fastener
fastens105511753fastens
gasmen93111563gasmen_
gasogene1045303gasogene
gasolene945553gasolene
gassed85217633gasse_d
gasser75017773gasse_r
gassers84714633gassers
gasses75724783gasse_s
gassing94216333gassing
glassine9329313glassine
haptene123810933haptene
hassel95614213hasse_l
hassels104311013hassels
hassle93711593hass_le
hasten95718563hasten_
hastened12239103hastened
hastener11259133hastener
hastens106214813hastens
hausen9610383hausen_
hausens1077633hausens
jasmine1636643jasmine
kamseen1344013kamseen
lasagne844063lasagne
lasses64827593lasse_s
lassie64917743lass_ie
lessee64116363lesse_e
lessen64212433lessen_
lessened935093lessened
lessens7409383lessens
massage1039893massage
masse75125293mass__e
massed94421323masse_d
masses85028713masse_s
masseter1037063masseter
masseur935703masseur
masseuse1044253masseuse
massing104318023massing
massive12289773massive
missend104411373missend
missense1037963missense
missent94318713missent
nascence1256183nascence
nascent9610523nascent
obscene1145243obscene
pangene102711963pangene
passade1039233passade
passage1039803passage
passant9813943passant
passe75525693pass__e
passed94320943passe_d
passel85117003passe_l
passels93913023passels
passenger1243413passenger
passer84721033passe_r
passerine1147083passerine
passers94717753passers
passes86030473passe_s
passing104318423passing
passive12239593passive
rassle63813203rass_le
sarsen6314233sarsen_
sarsenet8412943sarsenet
sarsens7311393sarsens
sassed76116173sasse_d
sasses64124393sasse_s
sassing84615553sassing
scalene9310773sca_lene
scene77220573__scene
sene46848053___sene
skene96118123__skene
tasse54821843tass__e
tassel66014773tasse_l
tasseled935593tasseled
tassels74510853tassels
tasses64826763tasse_s
tasset65925313tasse_t
tassets75012773tassets
tassie66017023tass_ie

Search took 10 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.1561145455.1
2DLD Change Limit1340272689.47014152.8
3Display Results2682680.1102436.4
 (SQL Overall)1786912689.73618353.6
 
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.