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

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

148 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
scratch144601(None) 
cratch134110791_cratch
scraich1436761scraich
scratchy1843651scratchy
catch125120372_c_atch
cranch133613532_cranch
crotch133410082_crotch
crutch13408242_crutch
ratch104221362__ratch
scootch1434462scootch
scotch13207522sc_otch
scraichs1543992scraichs
scraigh1335672scraigh
scratched1735392scratched
scratcher1635442scratcher
scratches1647322scratches
screech1435222screech
scrooch1444962scrooch
scrootch1542812scrootch
scrunch1444032scrunch
scultch1483542scultch
scutch13247082sc_utch
slatch114510532s_latch
snatch114310602s_natch
strath93216372strat_h
stretch1236412stretch
swatch14549282s_watch
batch124620103__batch
brach126123303_bra_ch
branch134014773_branch
bycatch1942063bycatch
caroch13911763_caroch
catchy16559583_c_atchy
clach124617823_cla_ch
clutch13367753_clutch
coach125919453_coa_ch
crack134120533_cra_ck
crash109120013_cra_sh
cratches153012543_cratches
crate76537403_crat_e
crated94827773_crated
crater85026643_crater
crates85736063_crates
craton84517193_craton
craunch1464443_craunch
crouch133910203_crouch
crunch13349503_crunch
crwth1337483_crwt_h
cultch13385953_cultch
cutch125116193_c_utch
grutch12285563_grutch
hatch135719593__hatch
klatch15445933_klatch
latch104620463__latch
match125621103__match
natch105018223__natch
orach105219233_ora_ch
patch125221223__patch
ranch105019793__ranch
rath76037663__rat_h
rematch1436193rematch
repatch1435843repatch
retch104818303__retch
rotch105815933__rotch
sauch104918773s__auch
scarce104013633sc_arce
scarph13429603sc_arph
scart76139773scart__
scarted104816123scarted
scarts85321493scart_s
scat65848373sc_at__
scathe114414993sc_athe
scats75930603sc_at_s
scatt76030093sc_at_t
scatts85914663sc_atts
scatty115310653sc_atty
schatchen1943853schatchen
sciatic11910173sciatic
sciatica12106113sciatica
sciatics12117273sciatics
scooch13228123sc_ooch
scorch13198093sc_orch
scouth115011153scout_h
scrag85916173scra__g
scraggy14304583scraggy
scrags95713803scra_gs
scraiched1744203scraiched
scraighs1443633scraighs
scram910621623scra__m
scrams105216623scra_ms
scrap97120403scra__p
scrape105917573scra_pe
scraped124313133scraped
scraper114513423scraper
scrapes116217663scrapes
scrapie115010943scrapie
scrappy16234473scrappy
scraps106017243scra_ps
scratchers1744293scratchers
scratchier1744343scratchier
scratchily2042553scratchily
scratching1844533scratching
scrawl11208093scra_wl
scrawls12177283scrawls
scrawly15197193scrawly
scrawny15213943scrawny
screechy1842773screechy
scrota8310203scrot_a
scrotal938493scrotal
scrotum1145133scrotum
scrunchy1852383scrunchy
sculch13226213sc_ulch
search113312423s_earch
seecatch1542693seecatch
serac75925203sera_c_
seracs84418573sera_cs
seraph114011163sera_ph
sheath12412893sheat_h
sketch1535363s_ketch
smutch13205843s_mutch
snatchy15355293s_natchy
snath86419803s_nat_h
snitch11357943s_nitch
splotch1442853splotch
sprat76635973sprat__
sprats85819933sprat_s
stanch113812373s_tanch
starch113013203s_tarch
stitch11419103s_titch
strata63616283strat_a
stratal72710603stratal
stratas73013583stratas
straths102711723straths
strati63518903strat_i
stratum9318253stratum
stratus73011733stratus
stretchy1644083stretchy
sumach135310113suma_ch
surah86823253sura__h
swarth126012083swart_h
swath115920383s_wat_h
switch14458913s_witch
thatch1435613_thatch
unlatch1245053unlatch
watch135617063__watch
wrath115715873_wrat_h
wretch14326533_wretch
xerarch1943843xerarch

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271487.48317910.9
3Display Results1481480.0463217.4
 (SQL Overall)1786911487.91922564.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.