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

131 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
scratches164731(None) 
cratches153012541_cratches
scratched1735381scratched
scratcher1635431scratcher
scratchers1744281scratchers
catches144320762_c_atches
cranches153114542_cranches
crotches153411292_crotches
crutches15359582_crutches
ratches123620462__ratches
scathes124515712sc_at_hes
schatchen1943852schatchen
schatchens2042682schatchens
scootches1635002scootches
scotches15179472sc_otches
scraiched1744202scraiched
scraichs1543992scraich_s
scratch1446012scratch__
scratchier1744332scratchier
scratchiest1844142scratchiest
scratchy1843652scratch_y
screeches1695642screeches
scrooches1645702scrooches
scrootches1743322scrootches
scrunches1635402scrunches
scultches1664292scultches
scutches15168882sc_utches
slatches131511522s_latches
snatches131410712s_natches
stretches1438282stretches
swatches16169962s_watches
batches144019613__batches
braches144621223_bra_ches
branches153613803_branches
britches15278683_britches
bycatches2142683bycatches
caches137926913_c_a_ches
caroches15710693_caroches
catcher143115823_c_atcher
catchers153114053_c_atchers
chatchkes23174743_chatchkes
clutches15307913_clutches
coaches144018693_coa_ches
cranched163210413_cranched
crashes124618403_cra_shes
cratch134110793_cratch__
crates85736053_crat__es
craunches1655723_craunches
creches14313093_cr_eches
crotched16428593_crotched
crotchet152711993_crotchet
crotchets16396293_crotchets
crouches153711283_crouches
crunches153711353_crunches
crutched16307463_crutched
cultches15316533_cultches
cutches143216453_c_utches
earaches13411303eara_ches
grutches14285853_grutches
hatches153420273__hatches
klatches17157133_klatches
latches123320123__latches
matches143219783__matches
oraches124216473_ora_ches
patches143320383__patches
ranches123620113__ranches
ratchet124218333__ratchet
ratchets133110263__ratchets
rematches1636653rematches
repatches1636713repatches
retches123318513__retches
rotches123515703__rotches
satchel123310303s__atchel
satchels13328163s__atchels
scathe114414993sc_at_he_
scathed134012643sc_at_hed
scooches15188413sc_ooches
scootched1763963scootched
scorches15189143sc_orches
scotched16187933sc_otched
scrabbles15206283scrabbles
scraich1436763scraich__
scraighed1643593scraighed
scraighs1443633scraigh_s
scrambles15146383scrambles
scrapes116217663scra__pes
scrapies124612473scra_pies
scrapples1534793scrapples
scratchily2042553scratchily
scratchiness1962383scratchiness
scratching1844533scratching
screeched17114333screeched
screecher16144473screecher
screechers17143673screechers
scrooched1763843scrooched
scrootched1842333scrootched
scrunched1744033scrunched
scrunchies1744343scrunchies
sculches15176273sc_ulches
scutched16186893sc_utched
scutcher15176963sc_utcher
scutchers16175643sc_utchers
scythes15356523sc_yt_hes
searches132112903s_earches
sheathes14610183sheat_hes
sketches1746823s_ketches
smutches15177273s_mutches
snatched14157633s_natched
snatcher13167753s_natcher
snatchers14146303s_natchers
snathes104816493s_nat_hes
snitches13148983s_nitches
soroches1338803sor_oches
soutaches1446443soutaches
spathes125116533s_pat_hes
splotches1643913splotches
sprattles1174883sprattles
stanches132312793s_tanches
starches131912913s_tarches
stitches131410593s_titches
straths102711713strat_h_s
stretched1546203stretched
stretcher1446283stretcher
stretchers1545163stretchers
swathes134115513s_wat_hes
switches16159133s_witches
thatches1637513_thatches
tranches132915513_tranches
unlatches1444293unlatches
watches153017373__watches
wretches16257283_wretches

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.1701051123.5
2DLD Change Limit1486411319.17316204.2
3Display Results1311310.0602183.3
 (SQL Overall)1786911319.40319003.6
 
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.