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

114 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
scratched173538(None) 
scraiched1744201scraiched
scratcher1635431scratcher
scratches1647311scratches
cranched163210412_cranched
cratches153012542_cratches
crotched16428592_crotched
crutched16307462_crutched
scathed134012642sc_at_hed
schatchen1943852schatchen
scootched1763962scootched
scotched16187932sc_otched
scraighed1643592scraighed
scratch1446012scratch__
scratchers1744282scratchers
scratchier1744332scratchier
scratchy1843652scratch_y
screeched17114332screeched
scrooched1763842scrooched
scrootched1842332scrootched
scrunched1744032scrunched
scutched16186892sc_utched
snatched14157632s_natched
stretched1546202stretched
batched154114243__batched
branched163210453_branched
cached145419203_c_a_ched
catcher143115823_c_atcher
catches144320763_c_atches
clutched16356033_clutched
coached153313843_coa_ched
cracked163514743_cra_cked
cranches153114543_cranches
crashed134214203_cra_shed
cratch134110793_cratch__
crated94827773_crat__ed
cratered1149673_cratered
craunched1764023_craunched
crotches153411293_crotches
crotchet152711993_crotchet
crouched16359143_crouched
crunched16328163_crunched
crutches15359583_crutches
grutched15284673_grutched
hatched163414463__hatched
latched133914063__latched
matched153513963__matched
patched153514623__patched
ranched133113603__ranched
ratches123620463__ratches
ratchet124218333__ratchet
rematched1745223rematched
repatched1745313repatched
retched133814273__retched
satchel123310303s__atchel
scarphed1635433sc_arphed
scarted104816123scart__ed
scathe114414993sc_at_he_
scathes124515713sc_at_hes
scatted103512773sc_at_ted
schatchens2042683schatchens
scooched16206683sc_ooched
scootches1635003scootches
scorched16187193sc_orched
scotches15179473sc_otches
scrabbled16154973scrabbled
scragged1335813scra_gged
scraich1436763scraich__
scraichs1543993scraich_s
scrambled16164813scrambled
scrammed1555003scra_mmed
scraped124313133scra__ped
scrapped1556533scra_pped
scratchiest1844143scratchiest
scratchily2042553scratchily
scratching1844533scratching
scrawled1445903scra_wled
screecher16144473screecher
screeches1695643screeches
scrooches1645703scrooches
scrootches1743323scrootches
scrunches1635403scrunches
scultches1664293scultches
scutcher15176963sc_utcher
scutches15168883sc_utches
scythed16385303sc_yt_hed
searched14209253s_earched
sheathed1547213sheat_hed
sketched1835393s_ketched
slatches131511523s_latches
smutched16165923s_mutched
snatcher13167753s_natcher
snatches131410713s_natches
snitched14166863s_nitched
spathed134013183s_pat_hed
splotched1742823splotched
sprattled1263303sprattled
stanched14208903s_tanched
starched14199313s_tarched
stitched14148203s_titched
stretcher1446283stretcher
stretches1438283stretches
swatches16169963s_watches
swathed144611933s_wat_hed
switched17157133s_witched
thatched1735433_thatched
unhatched1844133unhatched
unlatched1544213unlatched
unmatched1744203unmatched
unpatched1744053unpatched
unwatched1844083unwatched
watched163012823__watched
wrathed14298523_wrat_hed
wretched17276533_wretched

Search took 10 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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411149.01616486.4
3Display Results1141140.0462478.3
 (SQL Overall)1786911149.23519349.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.