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 “scale” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

207 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
scale7462914(None) 
sale44959701s_ale
scald84818121scald
scaled94822441scaled
scaler84321601scaler
scales84529311scales
scall74420371scall
scalp95217981scalp
scaly104718721scaly
scape96921841scape
scare75334461scare
shale85332831shale
spale74929211spale
stale55637101stale
swale85221591swale
ale36572342__ale
bale66353842_bale
cable95329912_cable
cade76443912_cade
cafe95230322_cafe
cage75339062_cage
cake105439962_cake
calf96339562_calf
calk105527662_calk
call66838672_call
calm85032362_calm
calo64936442_calo
calve105919922_calve
calx135722792_calx
came87648752_came
cane66653122_cane
cape87242782_cape
care66968372_care
carle74535702_carle
case65848082_case
cate66254602_cate
cave95941262_cave
cicale10314502cicale
cole66956112_cole
dale55643982_dale
escape103811662escape
gale56347322_gale
hale76052832_hale
kale86533752_kale
locale83915652locale
macle96127002macle
male66052302_male
oscule838192oscule
pale66055012_pale
quale143617852quale
rale45050562_rale
rescale93215482rescale
sabe66140572s_abe
sable74732162sable
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sal36462882s_al_
salep77022952s_alep
sales56055592s_ales
sall44544682s_all
salp64534092s_alp
sals46851672s_als
salt45758522s_alt
salve85022132s_alve
same65245642s_ame
sane45954342s_ane
sate45556102s_ate
save75741362s_ave
scab85926712sca_b
scabble13168652scabble
scabs94818642scabs
scad75725772sca_d
scads85419962scads
scag76626892sca_g
scags85520972scags
scalade10359262scalade
scalage103110532scalage
scalar83612432scalar
scalare93311832scalare
scalded11409762scalded
scalds94813692scalds
scalene9310772scalene
scaleni936882scaleni
scalers93817262scalers
scaleup1134482scaleup
scalier94316912scalier
scalls84218202scalls
scalped124411992scalped
scalpel11377712scalpel
scalper113912922scalper
scalps104315232scalps
scam85932352sca_m
scamp115717312scamp
scams94423972scams
scan65530452sca_n
scans74625102scans
scant79735072scant
scaped115519552scaped
scapes105122262scapes
scar66434202sca_r
scarce104013632scarce
scared95227292scared
scarer84524612scarer
scares85033002scares
scarey115016982scarey
scarf105427142scarf
scarlet91516942scarlet
scarp95724102scarp
scars75433532scars
scart76139772scart
scary105222592scary
scat65848372sca_t
scathe114414992scathe
scats75930602scats
scatt76030092scatt
scaup95515992scaup
scaur75814902scaur
scene77220572scene
schlep1347092schlep
scold85414862scold
scolex1538242scolex
scone74621832scone
scope94821482scope
score75526742score
scrape105917572scrape
scree720031712scree
sculk115112462sculk
scull75315762scull
sculp95314842sculp
scute75520942scute
seal45654372seal_
sealed74328362sealed
sealer63928962sealer
seals54839702seals
selle54428312selle
shade95125582shade
shake124726402shake
shaled105023952shaled
shales94731252shales
shaley123714992shaley
shall85024052shall
shalt85534492shalt
shaly114322862shaly
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
sial45938832sial_
sials54227242sials
sickle124418322sickle
sidle65124032sidle
skald104210172skald
skate94721552skate
slake93724052slake
slate55438282slate
slave84224032slave
small74016262small
smalt74729332smalt
smaze165012932smaze
smile74823922smile
snake94821112snake
snare54429982snare
soave84219052soave
socage91012122socage
socle7419572socle
sole46053672s_ole
space95325672space
spade84423322spade
spae65034322spa_e
spake114322742spake
spales84728102spales
spall74919302spall
spare75135562spare
spate74731582spate
spile75230082spile
stable83921642stable
stade64825302stade
stage65330192stage
stake95927532stake
staled74728102staled
staler64025822staler
stales65538292stales
stalk94518002stalk
stall54722352stall
stane55933002stane
staple84415822staple
stare54440262stare
state56237332state
stave85324992stave
stele55026842stele
stile54931572stile
stole54928812stole
style85519362style
suable83920552suable
suave83519872suave
suckle124015962suckle
swage94919562swage
swales93920762swales
sware85828212sware
tale46154162_tale
upscale11136322upscale
vale74937342_vale
wale74546432_wale
whale115517432whale

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538002071.59333772.8
3Display Results2072070.0633285.7
 (SQL Overall)1786912071.96990752.2
 
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.