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

153 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
scarts8532149(None) 
carts78946291_carts
scants85219721scants
scares85033001scares
scarfs114714681scarfs
scarps104718601scarps
scars75433531scar_s
scart76139771scart_
scats75930601sca_ts
scatts85914661scatts
smarts86218001smarts
starts65423121starts
acarus8312192acarus
arts49650262__arts
ascaris93613322ascaris
boarts84716872boarts
cants77036942_cants
carats85929022_carats
carbs96031462_carbs
cards85137932_cards
cares77369182_cares
carets85330772_carets
carks115534212_carks
carls77037422_carls
carns75937562_carns
carps96932252_carps
carrs75730852_carrs
cars67364762_car_s
cart66570342_cart_
carte75940422_carte
cartes86239472_cartes
casts77237792_casts
cats66356342_ca_ts
charts115823092charts
darts67635732_darts
ecarte84313502ecarte
ecartes94212562ecartes
escarps11397372escarps
escars83913132escar_s
escorts9418402escorts
farts88336842_farts
harts88441592_harts
hearts96218942hearts
karts97630112_karts
marts77442232_marts
oxcarts1634312oxcarts
parts77743372_parts
quarts154715932quarts
salts55431882s_alts
sards64736182s_ards
saris54544952s_aris
sarks96632462s_arks
saros55238062s_aros
scabs94818642sca_bs
scads85419962sca_ds
scags85520972sca_gs
scalds94813692scalds
scales84529312scales
scalls84218202scalls
scalps104315232scalps
scamps125014172scamps
scams94423972sca_ms
scans74625102sca_ns
scant79735072scant_
scanty114014662scanty
scapes105122262scapes
scar66434202scar__
scarab10310062scarab
scarabs1137292scarabs
scarce104013632scarce
scare75334462scar_e
scared95227292scared
scarer84524612scarer
scarers94618512scarers
scarey115016982scarey
scarf105427142scar_f
scarlets10178572scarlets
scarp95724102scar_p
scarph13429602scarph
scarphs14437412scarphs
scarry116311182scarry
scarted104816122scarted
scarves124511622scarves
scary105222592scar_y
scat65848372sca_t_
scatt76030092sca_tt
scatty115310652scatty
scaups105411932scaups
scaurs85512052scaurs
scents85317022scents
scoots85315942scoots
scores84725922scores
scorns85713022scorns
scots74025912sc_ots
scouts84817942scouts
scrags95713802scrags
scrams105216622scrams
scraps106017242scraps
scurfs113210812scurfs
scuts74522522sc_uts
sears54744912sear_s
seats54844342sea_ts
secants93413892secants
shafts125411442shafts
shards104319172shards
shares95236412shares
sharks135019722sharks
sharns95516982sharns
sharps115516082sharps
shirts94918342shirts
shorts95321742shorts
skats94621542ska_ts
skirts104111502skirts
skorts104211302skorts
slants64819082slants
slats55436902sla_ts
smalts85214892smalts
smarms105712532smarms
smart75834092smart_
smarty115013792smarty
snares65329032snares
snarfs95113422snarfs
snarks104815732snarks
snarls64016872snarls
snorts64116502snorts
soars54732512soar_s
sorts54536662s_orts
spaits85017472spaits
spares84834552spares
sparks124616362sparks
spars75431542spar_s
spats75031382spa_ts
spirts85317132spirts
sports84619182sports
sprats85819932sprats
spurts84814972spurts
stares66038752stares
starets73515922starets
stars55836572star_s
start55642312start_
startsy10536702startsy
stats55933362sta_ts
sturts63915142sturts
swards105415132swards
swarfs125612062swarfs
swarms116112172swarms
swart86234642swart_
swarth126012082swarth
swarths13537322swarths
swarty125812382swarty
swats85726862swa_ts
tarts57242022_tarts
warts814840402_warts

Search took 3 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 Filter178691825510.330541487.9
2DLD Change Limit825511532.25036689.3
3Display Results1531530.0463326.1
 (SQL Overall)1786911532.62668046.8
 
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.