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

247 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
scalene931077(None) 
scaleni936881scaleni
saline65132702s_aline
scalade10359262scalade
scalage103110532scalage
scalare93311832scalare
scale74629142scal__e
scaled94822442scale_d
scalenus1045542scalenus
scaler84321602scale_r
scalers93817262scalers
scales84529312scale_s
scaleup1134482scaleup
scaling103519372scaling
scavenge1442812scavenge
scene77220572sc__ene
squalene1745612squalene
stelene7310252stelene
abalone938903abalone
academe1244703academe
acaleph1453443acaleph
acalephe1552733acalephe
acarine9316003acarine
acauline1046903acauline
achene11313813ac_hene
agene65621583__agene
akene95818663__akene
alane56135613__alane
alee46652323__ale_e
aline57243153__aline
alkene104114003__alkene
alone55732963__alone
amylene12106883amylene
arene55329413__arene
baleen8613053_baleen
cadence1239063_cadence
cadent94120363_cadent
calcine11315273_calcine
caleche14297953_caleche
calender1138273_calender
calends1039523_calends
calesa8412473_calesa
callee84327293_callee
calque17289843_calque
calve105919923_cal_ve
calzone1848623_calzone
cane66653123_ca__ne
canine83826703_canine
careen84119493_careen
carline93923613_carline
caserne93710063_caserne
cassene93111543_cassene
catena8312483_catena
catenae9311373_catenae
cauline92215603_cauline
cayenne1244603_cayenne
chalone12312103chalone
clepe94617383_c_lepe
cline76428533_c_line
clone75728163_c_lone
colone85425003_colone
cymene1377393_cymene
escalade1144383escalade
escalate1039323escalate
escalope1244523escalope
escapee113310463escape_e
esculent1047183esculent
galeae74717453_galeae
galena74911093_galena
galere73716683_galere
hyaline132310723hyaline
maline84529083_maline
mescaline1348943mescaline
opaline9412483opaline
paleae84820293_paleae
praline93019743praline
sabine84020393s_abine
saclike131210123saclike
sale44959703s_al__e
salep77022953s_ale_p
saleps85014903s_aleps
sales56055593s_ale_s
salience10117903s_alience
salient7419763s_alient
salina64221123s_alina
salines74029413s_alines
salon55228553s_alon_
salons63823693s_alons
salpae84614273s_alpae
saltie63422433s_altie
saltine75018563s_altine
salute64418023s_alute
salve85022133s_al_ve
sane45954343s_a__ne
saree55044663s_are_e
sateen63815013s_ateen
savine94220283s_avine
scabble13168653scabble
scabland1344293scabland
scablike1635553scablike
scalable121710233scalable
scalades11258803scalades
scalado10276473scalado
scalages113010253scalages
scalar83612433scal_ar
scalares103210983scalares
scalars93711903scalars
scald84818123scal__d
scalded11409763scalded
scaldic1235943scaldic
scalding12339393scalding
scalds94813693scal_ds
scaleless1135513scaleless
scalelike1545253scalelike
scalepan1244513scalepan
scalepans1343823scalepans
scaleups1243393scaleups
scalier94316913scalier
scaliest101714403scaliest
scaliness1149303scaliness
scall74420373scal__l
scallop11237643scallop
scalls84218203scal_ls
scalp95217983scal__p
scalped124411993scalped
scalpel11377713scalpel
scalpels12345883scalpels
scalper113912923scalper
scalpers123710863scalpers
scalping133410453scalping
scalps104315233scal_ps
scaly104718723scal__y
scan65530453sca__n_
scandent1148493scandent
scanned104110893scanned
scanner94411813scanner
scans74625103sca__ns
scant79735073sca__nt
scape96921843sca__pe
scaped115519553scape_d
scapes105122263scape_s
scaping123715693scaping
scapose1147753scapose
scarce104013633sca_rce
scare75334463sca__re
scared95227293scare_d
scareder1135793scareder
scarer84524613scare_r
scarers94618513scarers
scares85033003scare_s
scarey115016983scare_y
scaring103421973scaring
scarless10189053scarless
scarlet91516943scarle_t
scarlets10178573scarlets
scathe114414993sca_the
scavenged1642153scavenged
scavenger1542193scavenger
scavenges1542903scavenges
scena74815783sc__ena
scend85516293sc__end
scenes84520353sc__enes
scent75831623sc__ent
scheme1379633sc_heme
schlep1347093schle_p
schlepp1662953schlepp
schleps1445483schleps
schliere1343843schliere
science1138783sc_ience
sclera838893sc_lera
sclerae937933sc_lerae
scoleces1237083scoleces
scolex1538243scole_x
scone74621833sc__one
scree720031713sc_re_e
screen85216023screen_
screened1137413screened
screener1037573screener
screens95212183screens
scrieve12448333scrieve
sealant73118303sealant
sealed74328363seale_d
sealer63928963seale_r
sealers74323553sealers
sealery104011053sealery
sealing83528563sealing
seamen84518563seamen_
seaplane1049163seaplane
secalose1046963secalose
sene46848053s___ene
sepaline10311343sepaline
serene63522353s_erene
setline7313923setline
shaken134113613shaken_
shale85332833shal__e
shaled105023953shale_d
shales94731253shale_s
shaley123714993shale_y
shapen114414653shapen_
shaven124213303shaven_
siamese936503siamese
silane62718053s_ilane
silence9310213s_ilence
sileni63312143s_ileni
silent64125843s_ilent
skene96118123s__kene
sklent103614353s_klent
skyline1436793skyline
smaltine1037833smaltine
spahee11313443spahe_e
spaldeen1142773spaldeen
spale74929213spal__e
spales84728103spale_s
spalpeen1252503spalpeen
sphene113412403s_phene
spleen8310263s_pleen
splent84720193s_plent
spline86020533s_pline
squalenes1845763squalenes
stale55637103stal__e
staled74728103stale_d
stalely1039213stalely
staleness9310783staleness
staler64025823stale_r
stales65538293stale_s
stalest73720173stalest
staling83925423staling
stamen84115943stamen_
stamened1137633stamened
stamens93411483stamens
stane55933003sta__ne
stanine73417073stanine
stilbene1043613stilbene
stolen64315063stolen_
styrene10116693styrene
subline9316893subline
subvene1238493subvene
sullen62914293sullen_
sullener857243sullener
swale85221593swal__e
swales93920763swale_s
sycamine1545723sycamine
talent6323323_talent
valence1268773_valence
valine94623093_valine
vocalese13165503vocalese
xylene1645793_xylene

Search took 7 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.420425454.8
2DLD Change Limit1340272476.40620922.1
3Display Results2472470.0962572.9
 (SQL Overall)1786912476.92225814.9
 
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.