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

253 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
scalare9331183(None) 
scalade10359261scalade
scalage103110531scalage
scalar83612431scalar_
scalares103210981scalares
scalars93711901scalars
escalade1144382escalade
escalate1039322escalate
salary9515212s_alary
scalable121710232scalable
scalades11258802scalades
scalado10276472scalado
scalages113010252scalages
scale74629142scal__e
scalene9310772scalene
scaler84321602scaler_
scalers93817262scalers
scalier94316912scalier
scalper113912922scalper
scare75334462sc__are
seaware1049622seaware
acylate12310533acylate
aglare7312423_aglare
alae45643753__ala_e
alane56135613__alane
alar46340073__alar_
alarm76621423__alarm
alary86123443__alary
alate55340323__alate
aware86420023__aware
blare75826233__blare
cabaret112519043_cabaret
cadre85419023_ca_dre
calami10313423_calami
calash11312433_calash
calcar10312753_calcar_
calcars11312653_calcars
calibre1136603_calibre
calker124917083_calker
callee84327293_callee
caller85125483_caller
calmer105216933_calmer
calorie92716893_calorie
calory11312843_calory
calque17289843_calque
calvary1537183_calvary
calve105919923_cal_ve
canape10913513_canape
canard9314763_canard
canary11314693_canary
carafe115416163_carafe
carate84734003_carate
care66968373_c__are
carfare12310073_carfare
caviare1238373_caviare
chare105231983_c_hare
clade85821013_c_lade
claret84026573_c_laret
claro75018693_c_laro
clary105719613_c_lary
clave105420153_c_lave
colure8314163_colure
curare84916953_curare
dealate83617843dealate
declare10411223declare
escaladed1343423escaladed
escalader1243233escalader
escalades1244403escalades
escalated1247303escalated
escalates1148823escalates
escalope1244523escalope
escapade1343303escapade
escolar946053escolar_
escolars1045343escolars
flare84823633__flare
galere73716673_galere
galore73514853_galore
glare65222953__glare
malar76424443_malar_
malars85020683_malars
malate84624553_malate
malgre9299303_malgre
ocular8610133ocular_
oculars948363oculars
oscular937933oscular_
osculate101010613osculate
oxalate1457623oxalate
palace104516913_palace
palate84226783_palate
sabre74821503s_a_bre
saccade12107033saccade
saccate111311763saccate
saclike131210123saclike
safari91110223s_afari
salaam8711013s_alaam
salable91415463s_alable
salad65321833s_ala_d
salads75316963s_alads
salal55425703s_ala_l
salals65120083s_alals
salami8313103s_alami
salaried9311023s_alaried
salaries8319573s_alaries
sale44959703s_al__e
saline65132703s_aline
salpae84614273s_alpae
salter64325083s_alter
saltie63422433s_altie
saltire73113033s_altire
salute64418023s_alute
salvage1138193s_alvage
salve85022133s_al_ve
salver94617753s_alver
samara8313853s_amara
sarape84817573s_arape
satara6315533s_atara
satire63218003s_atire
savage10410173s_avage
savate9313783s_avate
scabbard1544203scabbard
scabble13168653scabble
scabland1344293scabland
scablike1635553scablike
scalably15166703scalably
scalados11276083scalados
scalawag14142773scalawag
scald84818123scal__d
scalded11409763scalded
scaldic1235943scaldic
scalds94813693scal_ds
scaled94822443scal_ed
scaleni936883scaleni
scales84529313scal_es
scaleup1134483scaleup
scaling103519373scaling
scall74420373scal__l
scallop11237643scallop
scalls84218203scal_ls
scalp95217983scal__p
scalped124411993scalped
scalpel11377713scalpel
scalpers123710863scalpers
scalps104315233scal_ps
scaly104718723scal__y
scammer133611973scammer
scamper134613163scamper
scanner94411813scanner
scanter94215183scanter
scape96921843sc__ape
scapose1147753scapose
scapulae1255433scapula_e
scapular1245373scapular_
scapulars1343873scapulars
scapulary1643203scapulary
scar66434203sc__ar_
scarab10310063scara_b
scarabs1137293scarabs
scarce104013633sca_rce
scarcer113911373scarcer
scared95227293sc__ared
scarer84524603sc__arer
scarers94618503scarers
scares85033003sc__ares
scarey115016983sc__arey
scarf105427143sc__arf
scarfer124511083scarfer
scarier94017873scarier
scarp95724103sc__arp
scarper114814823scarper
scarred104512633sca_rred
scarry116311183sca_rry
scars75433533sc__ars
scart76139773sc__art
scary105222593sc__ary
scathe114414993sca_the
scatter93815173scatter
scauper11379453scauper
scaur75814903sca_ur_
scaurs85512053sca_urs
sceptre1135043sceptre
schliere1343843schliere
scholar1236953scholar_
scholars1336683scholars
sclaff1438313sc_laff
sclera838883sc_lera
sclerae937933sc_lerae
scolder103210333scolder
score75526733sc__ore
scrape105917573sc_rape
sculker13318323sculker
sculler99812153sculler
scutage1036333scutage
scutate9310323scutate
seafarer1144843seafarer
sealable101512693sealable
sealant73118303sealant
sealer63928963sealer_
sealers74323553sealers
sealery104011053sealery
seamark1336723seamark
seaplane1049163seaplane
seaward1148173seaward
seawares1139333seawares
secalose1046963secalose
secular92211533secular_
seculars10219393seculars
shale85332833shal__e
shalier103116423shalier
share86437083s__hare
silage72715303s_ilage
silane62718053s_ilane
skylark1343273skylark
slake93724053s__lake
slate55438283s__late
slave84224033s__lave
smallage1145183smallage
smaller93410333smaller
snare54429983s__nare
soakage1236103soakage
soilage8169353soilage
soilure736233soilure
solace83415823s_olace
solar55927343s_olar_
solate64526073s_olate
spale74929213spal__e
spaller92713473spaller
spare75135563s__pare
splake1259783s_plake
splore81611303s_plore
square154513363s_quare
stalag7310023stala_g
stalags838643stalags
stale55637103stal__e
staler64025823staler_
stalker113912253stalker
stalwart1147193stalwart
stare54440263s__tare
stature74410683stature
stealage946583stealage
stelae63716483stela_e
stelar64013863stelar_
stylar9358113stylar_
stylate10179773stylate
subalar9118073subalar_
sublate9315363sublate
sullage859913sullage
swale85221593swal__e
sware85828213s__ware
sycamore1542763sycamore
talar56225383_talar_
talars66021683_talars
teaware1048143teaware
unaware1038033unaware

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.1561145455.1
2DLD Change Limit1340272537.64017542.8
3Display Results2532530.0932720.4
 (SQL Overall)1786912537.88922650.7
 
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.