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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
scatt7603009(None) 
scant79735071scant
scart76139771scart
scat65848371sca_t
scats75930601scats
scatts85914661scatts
scatty115310651scatty
att35454652__att
batt65053872_batt
cant66362032_cant
cart66570342_cart
cast67159902_cast
cat58282342_ca_t
cate66254602_cate
cats66356342_cats
catty104520412_catty
matt65752662_matt
salt45758522s_alt
sat36288482s_a_t
sate45556102s_ate
sati45539332s_ati
scab85926712sca_b
scabs94818642scabs
scad75725772sca_d
scads85419962scads
scag76626892sca_g
scags85520972scags
scald84818122scald
scale74629142scale
scall74420372scall
scalp95217982scalp
scaly104718722scaly
scam85932352sca_m
scamp115717312scamp
scams94423972scams
scan65530452sca_n
scans74625102scans
scants85219722scants
scanty114014662scanty
scape96921842scape
scar66434202sca_r
scare75334462scare
scarf105427142scarf
scarp95724102scarp
scars75433532scars
scarts85321492scarts
scary105222592scary
scathe114414992scathe
scatted103512772scatted
scatter93815172scatter
scaup95515992scaup
scaur75814902scaur
scent75831622scent
scoot75729152scoot
scot66242612sc_ot
scots74025912scots
scout75031452scout
scut65835542sc_ut
scuta75815752scuta
scute75520942scute
scuts74522522scuts
seat47575562sea_t
seats54844342seats
secant84023292secant
sett45949052s_ett
shaft115725272shaft
shalt85534492shalt
shat76456602sha_t
shott85332192shott
skat87037902ska_t
skate94721552skate
skats94621542skats
slant55238702slant
slat46959022sla_t
slate55438282slate
slats55436902slats
slaty86523152slaty
smalt74729332smalt
smart75834092smart
snath86419802snath
spait75631602spait
spat66548522spa_t
spate74731582spate
spats75031382spats
start55642312start
stat47352692sta_t
state56237332state
stats55933362stats
stott56929792stott
swart86234642swart
swat77244442swa_t
swath115920382swath
swats85726862swats
watt75545412_watt

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 Filter178691538000.300595636.7
2DLD Change Limit53800941.84329191.5
3Display Results94940.0303133.3
 (SQL Overall)178691942.17382232.4
 
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.