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

226 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
ratchets13311026(None) 
hatchets163310381hatchets
latchets133410011latchets
rachets124516831ra_chets
ratches123620461ratche_s
ratchet124218331ratchet_
batchers153613272batchers
batches144019612batche_s
brachets154311982bra_chets
cachets145014262ca_chets
catchers153114052catchers
catches144320762catche_s
cratches153012542cratche_s
crotchets16396292crotchets
fitchets16307412fitchets
hatchels16368672hatchels
hatchers163113172hatchers
hatches153420272hatche_s
hatchet153317562hatchet_
latches123320122latche_s
latchet123117902latchet_
manchets15269572manchets
matchers153012432matchers
matches143219782matche_s
patchers153413302patchers
patches143320382patche_s
rachet115028972ra_chet_
rackets134916872ra_ckets
ranchers133311792ranchers
ranches123620112ranche_s
ratcheted1554782ratcheted
retches123318512retche_s
rochets124213472r_ochets
rotches123515702rotche_s
sachets123914102sa_chets
satchels13328162satchels
watchers163511792watchers
watches153017372watche_s
aches106132293_a_che_s
aitches123014363aitche_s
archers124414573_archers
arches114822043_arche_s
baches135426943ba_che_s
batched154114243batche_d
batcher144414853batche_r
bathers124720363bat_hers
bathes116524833bat_he_s
bitches144117063bitche_s
botchers153511543botchers
botches143716023botche_s
braches144621223bra_che_s
brachet144020313bra_chet_
brackets163310433bra_ckets
bractlets1344753bractlets
branches153613803branche_s
branchlets1743803branchlets
britches15278683britche_s
butchers153710183butchers
butches144315363butche_s
caches137926913ca_che_s
cachet134526413ca_chet_
catcher143115823catche_r
catchiest1638313catchiest
catchments1944453catchments
catchups1744373catchups
cathects1545793cat_hects
cranches153114543cranche_s
crochets15359833crochets
crotches153411293crotche_s
crotchet152711993crotchet_
crotchety19403813crotchety
crutches15359583crutche_s
cutches143216453cutche_s
datchas1347423datch_as
ditchers143610363ditchers
ditches133215713ditche_s
etchers123411293_etchers
etches114217763_etche_s
facets116316653fa_c_ets
fathers133916503fat_hers
faucets12578443fauc_ets
fetchers16328863fetchers
fetches153413893fetche_s
fitches153516193fitche_s
fitchet153113563fitchet_
fitchews19274773fitchews
gathers114315063gat_hers
gauchest1436293gauchest
grutches14285853grutche_s
hatcheck2244013hatcheck
hatchecks2343593hatchecks
hatched163414463hatche_d
hatchel153510753hatche_l
hatcher153314723hatche_r
hatchery19326383hatchery
hatchments2043883hatchments
hitchers16379993hitchers
hitches153616273hitche_s
hotches153814363hotche_s
hutches153613523hutche_s
itches114916213_itche_s
jackets205011373ja_ckets
ketches164012193ketche_s
kitchens17195783kitchens
klatches17157133klatche_s
laches116528343la_che_s
lancets93411163lanc_ets
larches124416443larche_s
latched133914063latche_d
latchkeys2141873latchkeys
lathers104321883lat_hers
lathes95127493lat_he_s
letches124015483letche_s
maches134827233ma_che_s
machete14310883ma_chete
machetes1539633ma_chetes
manches143818623manche_s
manchet143317773manchet_
marchers153710813marchers
marches143921173marche_s
matched153513963matche_d
matcher143214283matche_r
matchless1644673matchless
matchups1743063matchups
mutches143314283mutche_s
naches114622413na_che_s
nautches1336073nautche_s
notchers13279423notchers
notches123513653notche_s
oraches124216473ora_che_s
outcheats1445293outcheats
packets155114773pa_ckets
parches143720003parche_s
patched153514623patche_d
patcher143515143patche_r
patchiest1638353patchiest
pitchers153211483pitchers
pitches143617753pitche_s
planchets16236743planchets
rabbets11279423ra_bbets
racers84725433ra_c_ers
races74943243ra_c_e_s
racheted14149503ra_cheted
rachis114017653ra_ch_is
rachitis1348353ra_chitis
raciest92820013ra_ciest
racists92613323ra_cists
rackers134320453ra_ckers
racket125229423ra_cket_
rackety16499113ra_ckety
racquets1944763racquets
ramets83517393ra__mets
ramjets1635163ra_mjets
rances84625443ranc_e_s
ranched133113603ranche_d
rancher123013633ranche_r
ranchero13277423ranchero
rancheros14255793rancheros
ranchless1444453ranchless
ranchos123911393ranch_os
raphes115117453ra_phe_s
rashers104020903ra_shers
rashes95330153ra_she_s
rashest103916873ra_shest
ratafees1144143ratafees
ratatats846063ratatats
ratch104221363ratch___
ratcheting1643783ratcheting
ratels64518213rat__els
raters63936573rat__ers
rates55352013rat__e_s
rathe85821923rat_he__
rather94319733rat_he_r
ratines75328583ratine_s
ratites74920683ratite_s
ratteens8256053ratteens
rattens74213403rat_tens
ratters74422473rat_ters
rattiest83516113rattiest
rattlers83510293rattlers
rattles73217303rattle_s
raunches1368053raunche_s
reachers133515723reachers
reaches123423203reache_s
recheats1339193r_echeats
rechews1537293r_echews
rematches1636653rematche_s
repatches1636713repatche_s
retched133814273retche_d
richens12349733r_ichens
riches115022083r_iche_s
richest122813683r_ichest
rickets134915093r_ickets
ricochets1643413ricochets
roaches123616213roache_s
rochet115423003r_ochet_
rockets134615363r_ockets
rotche114311983rotche__
rouches124217893rouche_s
ruches114819583r_uche_s
sachems14348903sa_chems
sachet114725773sa_chet_
satchel123310303satche_l
satinets8311733satinets
scratchers1744283scratchers
scratches1647313scratche_s
slatches131511523slatche_s
snatchers14146303snatchers
snatches131410713snatche_s
swatches16169963swatche_s
taches114224173ta_che_s
tackets134914363ta_ckets
thatchers1744573thatchers
thatches1637513thatche_s
tracheas13410273tra_cheas
tranches132915513tranche_s
vetches153411263vetche_s
watched163012823watche_d
watcher153113403watche_r
watcheye19104273watcheye
watcheyes20103743watcheyes
watchouts1744033watchouts
wauchts15285283wauch_ts
witches152715793witche_s
wretches16257283wretche_s
yachts1437023ya_ch_ts

Search took 9 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 Filter1786911461620.1701051123.5
2DLD Change Limit1461622268.41017379.5
3Display Results2262260.0902511.1
 (SQL Overall)1786912268.67020610.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.