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

103 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
scratcher163543(None) 
scratched1735381scratched
scratchers1744281scratchers
scratches1647311scratches
scratchier1744331scratchier
catcher143115822_c_atcher
cratches153012542_cratches
schatchen1943852schatchen
scraiched1744202scraiched
scratch1446012scratch__
scratchy1843652scratch_y
screecher16144472screecher
scutcher15176962sc_utcher
snatcher13167752s_natcher
stretcher1446282stretcher
batcher144414853__batcher
catchers153114053_c_atchers
catches144320763_c_atches
catchier15329863_c_atchier
coacher143714113_coa_cher
cracker153114173_cra_cker
cranched163210413_cranched
cranches153114543_cranches
crasher124616153_cra_sher
cratch134110793_cratch__
crater85026633_crat__er
crotched16428593_crotched
crotches153411293_crotches
crotchet152711993_crotchet
cruncher15338073_cruncher
crutched16307463_crutched
crutches15359583_crutches
hatcher153314723__hatcher
matcher143214283__matcher
patcher143515143__patcher
rancher123013633__rancher
ratches123620463__ratches
ratchet124218333__ratchet
rather94319733__rat_her
satchel123310303s__atchel
scarcer113911373sc_arc_er
scathe114414993sc_at_he_
scathed134012643sc_at_hed
scathes124515713sc_at_hes
scatter93815173sc_at_ter
scattier10267583sc_attier
schatchens2042683schatchens
scootched1763963scootched
scootches1635003scootches
scorcher15196783sc_orcher
scotched16187933sc_otched
scotches15179473sc_otches
scouther1356943scout_her
scrabbler15195203scrabbler
scraggier1344133scraggier
scraich1436763scraich__
scraichs1543993scraich_s
scraighed1643593scraighed
scrambler15165043scrambler
scraper114513403scra__per
scrapper1466953scra_pper
scrappier1544413scrappier
scratchiest1844143scratchiest
scratchily2042553scratchily
scratching1844533scratching
scrawler1345883scra_wler
scrawlier1443893scrawlier
scrawnier1443633scrawnier
screeched17114333screeched
screechers17143673screechers
screeches1695643screeches
screechier1742983screechier
scrooched1763843scrooched
scrooches1645703scrooches
scrootched1842333scrootched
scrootches1743323scrootches
scrunched1744033scrunched
scrunches1635403scrunches
scultches1664293scultches
scutched16186893sc_utched
scutchers16175643sc_utchers
scutches15168883sc_utches
searcher13209103s_earcher
sheather1458213sheat_her
sketcher1735433s_ketcher
slatches131511523s_latches
slather103816063s_lat_her
snatched14157633s_natched
snatchers14146303s_natchers
snatches131410713s_natches
snatchier1455353s_natchier
snitcher13157373s_nitcher
stancher13198803s_tancher
stitcher13168383s_titcher
stretched1546203stretched
stretchers1545163stretchers
stretches1438283stretches
stretchier1544473stretchier
swatches16169963s_watches
swather134213593s_wat_her
switcher16177683s_witcher
thatcher1635653_thatcher
watcher153113403__watcher

Search took 7 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.1701051123.5
2DLD Change Limit1486411036.28323657.6
3Display Results1031030.0462239.1
 (SQL Overall)1786911036.49927495.2
 
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.