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

426 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
ranchers13331179(None) 
rancher123013631rancher_
ranchero13277421ranchero
rancheros14255791rancheros
ranches123620111ranche_s
anchors123912952_anchors
anthers103715202_anthers
archers124414572_archers
batchers153613272batchers
benchers153611012benchers
blanchers16307432blanchers
branches153613802branche_s
brunchers16296252brunchers
cancers114018582canc_ers
catchers153114062catchers
cranches153114542cranche_s
crunchers16316242crunchers
dancers103413092danc_ers
drenchers15296102drenchers
fanciers13358082fanciers
hatchers163113172hatchers
inchers123912522_inchers
lancers93616642lanc_ers
lanciers10308542lanciers
launchers1454332launchers
lunchers13349562lunchers
lynchers16285452lynchers
manches143818622manche_s
manchets15269572manchets
marchers153710812marchers
matchers153012432matchers
munchers15318772munchers
panthers13510782panthers
patchers153413302patchers
pinchers153510612pinchers
prancers123210332pranc_ers
punchers152610072punchers
racers84725432ra_c_ers
rachets124516832ra_chets
rackers134320452ra_ckers
rances84625442ranc_e_s
ranched133113602ranche_d
rancheria1444662rancheria
rancherias1544092rancherias
ranchless1444452ranchless
ranchos123911392ranch_os
rancors9811372ranc_ors
rancours1076712rancours
rangers83621042ran_gers
rankers113217462ran_kers
ranters73323642ran_ters
rashers104020912ra_shers
ratches123620462ratche_s
ratchets133110262ratchets
raunches1368052raunche_s
reachers133515722reachers
stanchers14206812stanchers
tranches132915512tranche_s
trenchers14288072trenchers
watchers163511792watchers
wenchers16319212wenchers
winchers16319222winchers
wrenchers17256332wrenchers
aches106132293_a_che_s
aethers103614943_aethers
anchor113911973_anchor_
anchos114214893_anch_os
ancress978613_ancress
angers75222543_an_gers
anglers84014823_anglers
answers1037043_answers
anthems12309423_anthems
anther93715063_anther_
antlers74014743_antlers
archer115016243_archer_
archery15478063_archery
arches114822043_arche_s
baches135426943ba_che_s
backers153821883ba_ckers
banders104324563ban_ders
bangers104020353ban_gers
banishers14258053banishers
bankers133919093ban_kers
banners94018713ban_ners
banshees13127863banshees
banters94623113ban_ters
bashers124820833ba_shers
batcher144414853batcher_
batches144019613batche_s
bathers124720363ba_thers
belchers153510023belchers
bencher144113483bencher_
benches143918603benche_s
blancher15338633blancher_
blanches153311603blanche_s
blenchers16356723blenchers
bluchers15359033bluchers
botchers153511543botchers
bracers114616703bra_c_ers
braches144621223bra_che_s
brachets154311983bra_chets
branched163210453branche_d
branchier1637133branchier_
branchless1743303branchless
branchlets1743803branchlets
branders114313093bran_ders
branners104010923bran_ners
breachers16369853breachers
broachers16328153broachers
bruncher15347783bruncher_
brunches153710453brunche_s
bunches144116033bunche_s
butchers153710183butchers
caches137926913ca_che_s
cachets145014263ca_chets
cancelers13247863cancelers
cancels114113313canc_els
cancer104220923canc_er_
canchas143212403canch_as
candlers114214103candlers
caners84629203can__ers
cankers134418753can_kers
canners93822663can_ners
canoers94318373can_oers
canters94827733can_ters
catcher143115823catcher_
catches144320773catche_s
chancers154313493chanc_ers
cinches144215773cinche_s
clenchers16276553clenchers
clinchers16336263clinchers
coachers154312303coachers
coanchors1645733coanchors
conches144019813conche_s
couchers153513863couchers
crackers164111723cra_ckers
cranched163210413cranche_d
crashers134013233cra_shers
cratches153012543cratche_s
craunches1655723craunche_s
cruncher15338073cruncher_
crunches153711353crunche_s
dackers143417043da_ckers
dancer94817613danc_er_
dances95120653danc_e_s
danders93921183dan_ders
dandlers103912053dandlers
dangers94818213dan_gers
danglers103610593danglers
dashers115016863da_shers
ditchers143610363ditchers
drencher14257213drencher_
drenches14309803drenche_s
dunches133312583dunche_s
etchers123411293_etchers
facers115519443fa_c_ers
fancier123412063fancier_
fancies124018783fancie_s
fanners103914653fan_ners
farcers124713443farc_ers
fathers133916503fa_thers
fencers123810623fenc_ers
fetchers16328863fetchers
filchers16286863filchers
finches153914193finche_s
flinchers17295473flinchers
franchisers1952813franchisers
frankers15348353fran_kers
frenches163311633frenche_s
ganaches1437413ganache_s
ganders93521703gan_ders
gangers94418603gan_gers
gathers114315073ga_thers
gaucher1337233gaucher_
glancers11408003glanc_ers
grangers103011973gran_gers
granters93614143gran_ters
grinches1436943grinche_s
hackers164619043ha_ckers
hanapers1346963hanapers
hances115621283hanc_e_s
handers114224333han_ders
handlers124014143handlers
hangers113120813han_gers
hankers144218133han_kers
hatchels16368673hatchels
hatcher153314723hatcher_
hatchery19326383hatchery
hatches153420273hatche_s
hatchets163310383hatchets
haunches1656963haunche_s
hitchers16379993hitchers
hunches153913463hunche_s
incher114114033_incher_
inches114419673_inche_s
jackers204214453ja_ckers
janglers16319373janglers
kashers143914023ka_shers
kenches163912273kenche_s
knackers13286843knackers
lacers85225253la_c_ers
laches116528343la_che_s
lackers134120543la_ckers
lancer84319973lanc_er_
lances84824103lanc_e_s
lancets93411163lanc_ets
landers84026213lan_ders
landlers94312833landlers
lanners73618333lan_ners
larches124416443larche_s
lashers104121833la_shers
latches123320123latche_s
latchets133410013latchets
lathers104321883la_thers
laughers1235923laughers
launcher1365563launcher_
launches1387903launche_s
leachers133712813leachers
lechers123313963_lechers
luncher123111413luncher_
lunches124115443lunche_s
lurchers13307153lurchers
lyncher15366553lyncher_
lynches15378873lynche_s
macers105321273ma_c_ers
maches134827233ma_che_s
managers112911003managers
manche133515103manche__
manchet143317773manche_t
mangers103521263man_gers
manglers113311903manglers
manners93417833man_ners
manurers1037593manurers
marcher143912973marcher_
marches143921173marche_s
mashers124621053ma_shers
matcher143214283matcher_
matches143219783matche_s
mincers113714853minc_ers
moochers15369123moochers
muncher143610373muncher_
munches144215793munche_s
naches114622413na_che_s
nances83618643nanc_e_s
nancies93516843nancie_s
notchers13279423notchers
ochers113915303__ochers
oraches124216473ora_che_s
pacers105124543pa_c_ers
packers153818893pa_ckers
painches1588913painche_s
panaches15310283panache_s
pancreas1235393pancreas
panders103423733pan_ders
paniers94717333pan_iers
panners93621273pan_ners
panniers10488853panniers
panoches1548123panoche_s
panther12611443panther_
panzers184012013pan_zers
parches143720003parche_s
patcher143515143patcher_
patches143320383patche_s
paunches1568173paunche_s
peachers153213843peachers
perchers153611523perchers
pincers113916503pinc_ers
pincher143812713pincher_
pinches144117933pinche_s
pinschers1644373pinschers
pitchers153211483pitchers
planches153111863planche_s
planchets16236743planchets
poachers152910763poachers
prancer113613383pranc_er_
prances113618773pranc_e_s
preachers16339573preachers
puncher143311673puncher_
punches144816133punche_s
quenchers2343173quenchers
rabblers123810853rabblers
racer75233023ra_c_er_
races74943243ra_c_e_s
rachet115028973ra_che_t
rachis114017653ra_ch_is
racier85120973ra_cier_
racker124824553ra_cker_
rackets134916873ra_ckets
rafflers14317363rafflers
rafters103715633ra_fters
raiders84615143ra_iders
railers74420663ra_ilers
raincheck2041893raincheck
rainchecks2151753rainchecks
raisers73617393ra_isers
rakers104123573ra__kers
ralliers84010833ralliers
ramblers124010373ramblers
rammers113715043ra_mmers
rance75028513ranc_e__
ranch105019793ranch___
ranching141712043ranching
ranchman1546043ranchman
ranchmen1545833ranchmen
rancho114310853ranch__o
rancor8810373ranc_or_
rancored1137223rancored
rancour987133rancour_
randier83618473randier_
randies84225663randie_s
ranees64623963ran__ees
ranger73925523ran_ger_
ranges73826923ran_ge_s
rangier83714353rangier_
ranker105021903ran_ker_
rankles113114543rankle_s
rankless12268233rankless
rankness12267943rankness
ransackers1643343ransackers
ransomers1146873ransomers
ranter63826823ran_ter_
rapers84327183ra__pers
raphes115117453ra_phe_s
rapiers95012873ra_piers
rappers113618443ra_ppers
rasers64526783ra__sers
rasher95024123ra_sher_
rashes95330153ra_she_s
raspers94415923ra_spers
rasters74629023ra_sters
ratchet124218333ratche_t
raters63936583ra__ters
rather94319743ra_ther_
ratters74422473ra_tters
rattlers83510293rattlers
raunchier1443713raunchier_
ravagers1235573ravagers
ravelers113310863ravelers
raveners11309123raveners
ravers94628183ra__vers
ravishers1564783ravishers
razers154919613ra__zers
reacher123718293reacher_
reaches123423203reache_s
rechews1537293r_echews
renders83821673ren_ders
renegers9248793renegers
renewers11238183renewers
renters74224813ren_ters
rentiers83311763rentiers
rescuers1037363rescuers
retches123318513retche_s
revanches1746253revanche_s
ricers84120993r_ic_ers
richens12349733r_ichens
richer114015043r_icher_
riches115022083r_iche_s
ringers83922953rin_gers
rinsers73815743rin_sers
roaches123616213roache_s
rochets124213473r_ochets
rockers133916553r_ockers
romancers1345733romanc_ers
rotches123515703rotche_s
rouches124217893rouche_s
roughers12329183roughers
ruches114819583r_uche_s
runners74212453run_ners
runovers1134473runovers
rushers103816103r_ushers
sachems14348903sa_chems
sachets123914103sa_chets
sackers133820223sa_ckers
sanders84025943san_ders
sangers84421943san_gers
satchels13328163satchels
saucers93712133sauc_ers
sauciers1076733sauciers
scratchers1744293scratchers
searchers14197353searchers
snackers143010223snackers
snatchers14146313snatchers
stancher13198813stancher_
stanches132312793stanche_s
taches114224173ta_che_s
tackers134319623ta_ckers
tanagers9259003tanagers
tanglers92911973tanglers
tankers113416913tan_kers
tanners74018393tan_ners
teachers133212393teachers
tenches123515523tenche_s
thatchers1744583thatchers
tochers123413093_tochers
touchers133611213touchers
tracers94917843tra_c_ers
tracheas13410273tra_cheas
trackers143512853tra_ckers
trances93919643tranc_e_s
tranche123312223tranche__
transfers1238053transfers
trashers113013643tra_shers
trencher13279313trencher_
trenches133512603trenche_s
unanchors1442613unanchors
vanishers15186613vanishers
vanners103612843van_ners
vouchers16418623vouchers
wanders114221333wan_ders
wanglers123310033wanglers
wankers144514713wan_kers
wanters104420093wan_ters
washers134517523wa_shers
watcher153113403watcher_
watches153017373watche_s
welchers16338053welchers
wencher153811133wencher_
wenches152914133wenche_s
wincers123415363winc_ers
wincher153410653wincher_
winches154714373winche_s
wranglers1344273wranglers
wrencher16287783wrencher_
wrenches163210233wrenche_s
yachters1633883ya_chters
zanders173015793zan_ders

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.1731032896.0
2DLD Change Limit1461624268.18617855.1
3Display Results4264260.1562730.8
 (SQL Overall)1786914268.51520985.4
 
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.