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

107 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
scarfs11471468(None) 
scares85033001scares
scarf105427141scarf_
scarps104718601scarps
scars75433531scar_s
scarts85321491scarts
scurfs113210811scurfs
snarfs95113421snarfs
swarfs125612061swarfs
acarus8312192acarus
arfs76029962__arfs
ascaris93613322ascaris
barfs104826002_barfs
caffs135417372_caffs
calfs104919382_calfs
carbs96031462_carbs
cards85137932_cards
cares77369182_cares
carks115534212_carks
carls77037422_carls
carns75937562_carns
carps96932252_carps
carrs75730852_carrs
cars67364762_car_s
carts78946292_carts
curfs105122142_curfs
dwarfs13436272dwarfs
escarps11397372escarps
escars83913132escar_s
sards64736182s_ards
saris54544952s_aris
sarks96632462s_arks
saros55238062s_aros
scabs94818642sca_bs
scads85419962sca_ds
scags85520972sca_gs
scalds94813692scalds
scales84529312scales
scalls84218202scalls
scalps104315232scalps
scamps125014172scamps
scams94423972sca_ms
scans74625102sca_ns
scants85219722scants
scapes105122262scapes
scar66434202scar__
scarab10310062scarab
scarabs1137292scarabs
scarce104013632scarce
scare75334462scar_e
scared95227292scared
scarer84524612scarer
scarers94618512scarers
scarey115016982scarey
scarfed134711182scarfed
scarfer124511082scarfer
scarfers13408462scarfers
scarify1537442scarify
scarp95724102scar_p
scarph13429602scarph
scarphs14437412scarphs
scarry116311182scarry
scart76139772scar_t
scarves124511622scarves
scary105222592scar_y
scats75930602sca_ts
scatts85914662scatts
scaups105411932scaups
scaurs85512052scaurs
sclaffs1543572sclaffs
scoffs14347502scoffs
scores84725922scores
scorns85713022scorns
scrags95713802scrags
scrams105216622scrams
scraps106017242scraps
scuffs14419052scuffs
scurf104719322scurf_
scurfy14338762scurfy
sears54744912sear_s
serfs84922012s_erfs
shards104319172shards
shares95236412shares
sharifs13279902sharifs
sharks135019722sharks
sharns95516982sharns
sharps115516082sharps
smarms105712532smarms
smarts86218002smarts
snares65329032snares
snarf86525422snarf_
snarks104815732snarks
snarls64016872snarls
soars54732512soar_s
spares84834552spares
sparks124616362sparks
spars75431542spar_s
staffs12349752staffs
stares66038752stares
stars55836572star_s
starts65423122starts
surfs85022542s_urfs
swards105415132swards
swarf115324652swarf_
swarms116112172swarms
wharfs1546372wharfs
zarfs174713622_zarfs

Search took 4 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.360496363.9
2DLD Change Limit825511072.59331836.1
3Display Results1071070.0303566.7
 (SQL Overall)1786911072.98359903.1
 
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.