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

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
scare7533446(None) 
care66968371_care
scale74629141scale
scape96921841scape
scar66434201scar_
scarce104013631scarce
scared95227291scared
scarer84524611scarer
scares85033001scares
scarey115016981scarey
scarf105427141scarf
scarp95724101scarp
scars75433531scars
scart76139771scart
scary105222591scary
score75526741score
share86437081share
snare54429981snare
spare75135561spare
stare54440261stare
sware85828211sware
acari75020282acari
acre67330772ac_re
are37874572__are
ascared10399522ascared
aware86420022aware
bare65460522_bare
blare75826232blare
cade76443912_cade
cadre85419022_cadre
cafe95230322_cafe
cage75339062_cage
cake105439962_cake
came87648752_came
cane66653122_cane
cape87242782_cape
car59165562_car_
carb85143162_carb
card710245872_card
cared86050092_cared
carer74942332_carer
cares77369182_cares
caret75360562_caret
carex144822302_carex
cark105539272_cark
carl65144782_carl
carle74535702_carle
carn66245432_carn
carp85139812_carp
carr65434702_carr
cars67364762_cars
carse74934332_carse
cart66570342_cart
carte75940422_carte
carve106227752_carve
case65848082_case
cate66254602_cate
cave95941262_cave
cere66741472_cere
chare105231982chare
cire65836372_cire
core67263112_core
cure66149122_cure
dare55848862_dare
decare93919152decare
ecarte84313502ecarte
escape103811662escape
escar74011992escar_
escarp10449002escarp
escars83913132escars
fare76354462_fare
flare84823632flare
glare65222952glare
hare76255732_hare
mare64759332_mare
nacre75715362nacre
ochre103411592ochre
pare66760842_pare
quare143920542quare
rare45348432_rare
sabe66140572s_abe
sabre74821502sabre
sacra74516992sacra
sacred94917102sacred
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sale44959702s_ale
same65245642s_ame
sane45954342s_ane
sard55344242s_ard
saree55044662s_aree
sarge65531132s_arge
sari45444042s_ari
sark84938972s_ark
sate45556102s_ate
save75741362s_ave
scab85926712sca_b
scabs94818642scabs
scad75725772sca_d
scads85419962scads
scag76626892sca_g
scags85520972scags
scalare93311832scalare
scald84818122scald
scaled94822442scaled
scaler84321602scaler
scales84529312scales
scall74420372scall
scalp95217982scalp
scaly104718722scaly
scam85932352sca_m
scamp115717312scamp
scams94423972scams
scan65530452sca_n
scans74625102scans
scant79735072scant
scaped115519552scaped
scapes105122262scapes
scarab10310062scarab
scarcer113911372scarcer
scarers94618512scarers
scarfed134711182scarfed
scarfer124511082scarfer
scarfs114714682scarfs
scarier94017872scarier
scarlet91516942scarlet
scarped124314402scarped
scarper114814822scarper
scarph13429602scarph
scarps104718602scarps
scarred104512632scarred
scarry116311182scarry
scarted104816122scarted
scarts85321492scarts
scarves124511622scarves
scat65848372sca_t
scathe114414992scathe
scats75930602scats
scatt76030092scatt
scaup95515992scaup
scaur75814902scaur
scaurs85512052scaurs
scene77220572scene
scone74621832scone
scope94821482scope
scored94621132scored
scorer84818262scorer
scores84725922scores
scorn75817452scorn
scrag85916172scrag
scram910621622scram
scrap97120402scrap
scrape105917572scrape
scree720031712scree
screw109318542sc_rew
scry96017762sc_ry
scurf104719322scurf
scute75520942scute
sear47353842sear_
seared75232842seared
searer65432022searer
sears54744912sears
secure8513532secure
sere46153472s_ere
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
shard96125962shard
shared105829062shared
sharer95025482sharer
shares95236412shares
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shave114425892shave
shire84727132shire
shore85432652shore
sire46150412s_ire
skate94721552skate
slake93724052slake
slate55438282slate
slave84224032slave
smarm95517602smarm
smart75834092smart
smaze165012932smaze
snake94821112snake
snared74824552snared
snarer64620842snarer
snares65329032snares
snarf86525422snarf
snark95419942snark
snarl54921082snarl
snore55424952snore
soar46838672soar_
soared74324292soared
soarer64522242soarer
soars54732512soars
soave84219052soave
socage91012122socage
sore47059532s_ore
space95325672space
spade84423322spade
spae65034322spa_e
spake114322742spake
spale74929212spale
spar65433302spar_
spared95427492spared
sparer84524962sparer
spares84834552spares
sparge94216052sparge
spark114920892spark
spars75431542spars
sparse84516342sparse
spate74731582spate
spire75828692spire
spore75428592spore
square154513362square
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
star48037762star_
stared75429872stared
starer64027362starer
stares66038752stares
stark95425622stark
stars55836572stars
start55642312start
starve94613742starve
state56237332state
stave85324992stave
stere55328542stere
store56333812store
suave83519872suave
sucre75019102sucre
sure45447412s_ure
swage94919562swage
swale85221592swale
sward94221462sward
swarf115324652swarf
swarm106218842swarm
swart86234642swart
swore84920822swore
tare45957622_tare
urare56322552urare
ware76254722_ware
yare75636942_yare

Search took 5 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.626285448.9
2DLD Change Limit538002533.60614919.6
3Display Results2532530.1601581.3
 (SQL Overall)1786912534.39240685.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.