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

463 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
shearers11391132(None) 
hearers104319781_hearers
sharers104720621sh_arers
shearer104414691shearer_
smearers10308621smearers
spearers103711141spearers
swearers11328581swearers
bearers94619592_bearers
cheaters133613512cheaters
cheerers13319542cheerers
clearers10349302clearers
fearers104815272_fearers
headers113819392_headers
healers104319462_healers
heapers123616672_heapers
hearer94323652_hearer_
heaters104225222_heaters
heavers133717192_heavers
rearers74323562_rearers
scarers94618512s_carers
sealers74323552s_ealers
seamers94719432s_eamers
searer65432022s_earer_
seaters74028942s_eaters
shaders115915552sh_aders
shakers144015562sh_akers
shapers124016892sh_apers
sharer95025482sh_arer_
shares95236412sh_are_s
sharkers154011052sh_arkers
sharpers133810942sh_arpers
shavers134115092sh_avers
sheared114516012sheare_d
shearlegs1342492shearlegs
shears93820902shea__rs
sheathers1557552sheathers
sheaves134412972sheave_s
shedders13267432shedders
sheerer103813852sheerer_
sheers94322402she__ers
sheeters113111862sheeters
shellers112812582shellers
shelters113412812shelters
shelvers14388812shelvers
shewers134312052she_wers
smearer94110402smearer_
snarers74216662s_narers
sneakers12308642sneakers
sneerers8309802sneerers
soarers74118092s_oarers
sparers94519612s_parers
speakers14299452speakers
spearer93913662spearer_
squarers17338022squarers
starers74522312s_tarers
stealers83412212stealers
steamers103410872steamers
steerers82511352steerers
sugarers936302sugarers
swearer10349952swearer_
sweaters113811062sweaters
tearers75218232_tearers
theaters114211902theaters
wearers104615902_wearers
adherers1296923adhe_rers
beaders104120183_beaders
beakers134216873_beakers
bearer85323913_bearer_
beaters94925043_beaters
beavers124417323_beavers
behavers16205613behavers
beheaders1545153beheaders
besmearers1442833besmearers
bleaters103412323bleaters
breakers143810973breakers
carers85133963__carers
chafers154512743ch_afers
chares115631803ch_are_s
chargers144011323ch_argers
charmers154211333ch_armers
charrs115219193ch_ar_rs
charters134115583ch_arters
chasers123714923ch_asers
chawers154412053ch_awers
cheapens15305943cheapens
cheaper144010583cheaper_
cheater124816963cheater_
checkers19317843checkers
cheders134512393che_ders
cheepers15329013cheepers
cheerer123511763cheerer_
cheers114518913che__ers
chequers2234103chequers
chevres15379793chevre_s
chevrets16255323chevrets
chewers154111143che_wers
cleaners103610543cleaners
clearer93710823clearer_
cleavers13398873cleavers
coherers132310733cohe_rers
creamers124111313creamers
creasers103612843creasers
darers75921873__darers
dealers84118613_dealers
dearer74822803_dearer_
dreamers11369003dreamers
eagers74523683__eagers
earners74016453__earners
eaters65535953__eaters
farers95924053__farers
fearer94820183_fearer_
fuehrers1442613fuehrers
gleamers11306563gleamers
gleaners9348073gleaners
greasers93410253greasers
haeres94017033_haere_s
halers94926913_h_alers
harems115513823_h_arems
hares86255543_h_are_s
harmers124116593_h_armers
harpers124916203_h_arpers
haters94930403_h_aters
havers124721483_h_avers
hayers124415943_h_ayers
hazers184615953_h_azers
header104422543_header_
healer94221803_healer_
heaper114119523_heaper_
hearkens15336693_hearkens
hears86737373_hea__rs
hearses104414543_hearses
heartens113010153_heartens
hearths135311073_hearths
hearts96218943_hear_ts
heater94828303_heater_
heathers143914733_heathers
heavens13439303_heavens
heaver124819673_heaver_
heaves124120303_heave_s
heders104119763_he_ders
hedgers124310263_hedgers
heeders114213743_heeders
heelers103815633_heelers
hefters134312003_hefters
heifers1337933_heifers
heiress1036813_heiress
hellers103619833_hellers
helpers123311853_helpers
hemmers143310843_hemmers
herders113914123_herders
heres86245903_he_re_s
hewers123715273_he_wers
hexers165612753_he_xers
hirers94518063_h_irers
hoarders12307433_hoarders
hoaxers17327133_hoaxers
jeerers14328923_jeerers
kneaders1384713kneaders
leaders83819603_leaders
leakers113415423_leakers
leaners73718173_leaners
leapers93716663_leapers
learners8398153_learners
leasers74717843_leasers
leavers103717783_leavers
meaners94415243_meaners
nearer64618893_nearer_
parers85530743__parers
pearlers1039033_pearlers
phreakers1834673phreakers
pleaders113210183pleaders
pleasers104010293pleasers
pleaters103613793pleaters
preavers13910263preavers
preparers13197673preparers
readers83823773_readers
reamers94221083_reamers
reapers93520453_reapers
rearer64928913_rearer_
reavers108320743_reavers
rehearsers13273863rehearsers
reheaters122010273reheaters
roarers73812743_roarers
sabers85224733s__abers
sakers104125433s__akers
sarees65329943s__arees
savers93825923s__avers
savorers1157223savorers
sawers94620163s__awers
sayers94221593s__ayers
scalers93817263s_calers
scarer84524613s_carer_
scares85033003s_care_s
scarfers13408463s_carfers
scarpers124712513s_carpers
scepters1237793scepters
schemers1576713sche_mers
scorers94115323s_corers
scourers10348533scourers
scrapers125510533scrapers
screamers13236263screamers
seabeds10417223s_eabeds
seafarers1244143seafarers
sealer63928963s_ealer_
sealery104011053s_ealery
seamer84223613s_eamer_
searchers14197353s_earchers
seared75232843s_eare_d
searest73322023s_earest
sears54744913s_ea__rs
seater64534163s_eater_
secrets9311773s_ecrets
securers1057153securers
seders74420283s_e_ders
seeders83017113s_eeders
seekers113712333s_eekers
seemers93814333s_eemers
seeress7311573s_eeress
seers55136383s_e__ers
seiners74219273s_einers
seisers73816393s_eisers
seizers164112503s_eizers
sellers73721323s_ellers
senders83022353s_enders
serer55935513s_e_rer_
seres55448893s_e_re_s
sergers83815633s_ergers
servers103214833s_ervers
setters73822063s_etters
severs94121123s_e_vers
sewers94719723s_e_wers
shader104218763sh_ader_
shades105924533sh_ade_s
shaker134319463sh_aker_
shakes135024593sh_ake_s
shales94731253sh_ale_s
shames114726223sh_ame_s
shammers153710843shammers
shaper114119933sh_aper_
shapes115124953sh_ape_s
shards104319173sh_ar_ds
share86437083sh_are__
shared105829063sh_are_d
sharias102516003sh_arias
sharifs13279903sh_arifs
sharker144313813sh_arker_
sharks135019723sh_ar_ks
sharns95516983sh_ar_ns
sharpens13377813sh_arpens
sharper124312703sh_arper_
sharps115516083sh_ar_ps
shatters113313913shatters
shaver123718913sh_aver_
shaves125224933sh_ave_s
sheafed14388973sheafe_d
sheafs124912883shea__fs
sheals94420643shea__ls
shear85424833shea__r_
shearing123915903shearing
shearings13337563shearings
shearwaters1751973shearwaters
sheas86331793shea___s
sheather1458233sheather_
sheathes14610193sheathes
sheaths1358753shea_ths
sheave124514003sheave__
sheaved143411633sheave_d
shebeens1343333shebeens
shedder12339323shedder_
sheeneys14294903sheeneys
sheens95116993she__ens
sheer84726893she__er_
sheered113515463sheere_d
sheerest11310083sheerest
sheerlegs1343293sheerlegs
sheerness1236273sheerness
sheeter103814913sheeter_
sheets93918503she__ets
sheeves133911953sheeve_s
shekels1436043she_kels
sheller103515893sheller_
shelter103214963shelter_
shelterers1344343shelterers
shelver134211063shelver_
shelves134112093shelve_s
shepherd1744373shepherd
shepherds1843223shepherds
sheqels1934753she_qels
sherbert1348793sherbert
sherberts1443593sherberts
sherbets1335213sherbets
sherds105614723she_r_ds
shereef1337743she_reef
shereefs1433863shereefs
sherifs13299683she_rifs
sherpas1238093she_rpas
sherries111812903sherries
sherris10168803she_rris
sherry124510413she_r_ry
shewer124515113she_wer_
shickers173012823shickers
shielders1334763shielders
shiers94921753sh__iers
shifters14319863shifters
shikarees1643073shikarees
shikkers14326523shikkers
shimmers15269413shimmers
shiners104015943sh_iners
shippers153012313shippers
shires95225573sh_ire_s
shirkers15319583shirkers
shirrs94413173sh_ir_rs
shivarees1543953shivarees
shiverers15155773shiverers
shivers133714833sh_ivers
shmears1277073shmea__rs
shnorrers1243533shnorrers
shoaler102610083shoaler_
shockers17319463shockers
shoemakers1943493shoemakers
shoers94518333sh__oers
shoetrees1244353shoetrees
shooters112811583shooters
shoppers153010763shoppers
shores94830413sh_ore_s
shouters113510623shouters
shovers134613003sh_overs
showerers1545073showerers
showers134612683sh_owers
shredders1463713shredders
shreds105613053sh__reds
shrews129313923sh__rews
shrivers14419103shrivers
shuckers17388133shuckers
shudders13316643shudders
shunners11317743shunners
shunters113210753shunters
shushers14267053shushers
shutters113611353shutters
shyers124712203sh__yers
shysters14106463shysters
skaters113512963s_katers
skeanes113610713skeane_s
skeeters12298963skeeters
skelters12349373skelters
skewers14498383ske_wers
slakers114115753s_lakers
slaters73123733s_laters
slavers103716503s_lavers
slayers104513323s_layers
sleaves103813203sleave_s
sleazes162810333sleaze_s
sledders10257373sledders
sleekers12377993sleekers
sleepers103110113sleepers
smeared104510623smeare_d
smearier1036953smearier_
smears84714433smea__rs
smellers10329773smellers
smelters103310513smelters
snarer64620843s_narer_
snares65329033s_nare_s
snarlers8298753s_narlers
sneaker112910453sneaker_
sneerer73512313sneerer_
sneers64016173sne__ers
sneezers17246143sneezers
snorers74313803s_norers
soakers114114953s_oakers
soapers93715923s_oapers
soarer64522243s_oarer_
socagers1196363socagers
solacers10268893solacers
spacers113813873s_pacers
spaders104214473s_paders
sparer84524963s_parer_
spares84834553s_pare_s
spargers11389733s_pargers
sparkers144111313s_parkers
speaker133311213speaker_
speared104314423speare_d
spears84019473spea__rs
specters122811063specters
speeders11339313speeders
speers85019953spe__ers
spellers102812763spellers
spelters103912243spelters
spencers12269193spencers
spenders113211743spenders
spewers124210663spe_wers
spheres123114353sphe_re_s
sprayers13367053sprayers
spreaders1236503spreaders
spurrers10338463spurrers
squarer163410663squarer_
squares163714463square_s
squeakers2284113squeakers
squealers1894453squealers
stagers84116673s_tagers
starer64027363s_tarer_
stares66038753s_tare_s
starets73515923s_tarets
starkers123712393s_tarkers
starters83714773s_tarters
starvers11459643s_tarvers
staters73922343s_taters
stayers103813633s_tayers
steadiers1035083steadiers
stealer72913983stealer_
steamer93313093steamer_
stearins8312143stearins
steepers103011373steepers
steerer73113633steerer_
steers63820983ste__ers
stemmers12378443stemmers
steppers12289283steppers
stereos74314973ste_reos
steres63929533ste_re_s
stirrers8266943stirrers
storers75018683s_torers
strafers11379913strafers
strayers113510143strayers
streakers13218143streakers
streamers11228083streamers
subareas1038623subareas
sugarer837323sugarer_
swagers114211023s_wagers
swarmers1346323s_warmers
swayers13398853s_wayers
swears94114073swea__rs
sweater103712723sweater_
sweepers13348163sweepers
swelters113110193swelters
swervers1455213swervers
tearer64822903_tearer_
teasers75317243_teasers
thalers106212263th_alers
thawers13428483th_awers
theater104014253theater_
theatres11298643theatre_s
theorems1344693theorems
theres96525473the_re_s
threaders1365743threaders
threapers1444773threapers
thwarters1542843thwarters
treaders93311843treaders
treaters83615853treaters
upbearers1343033upbearers
upheavers1742593upheavers
vealers103214293_vealers
weaners104613833_weaners
wearer94319413_wearer_
weavers133714463_weavers
whalers13529703wh_alers
wheatears1542693wheatears
wheatens1454663wheatens
wheelers14287743wheelers
wheezers23265283wheezers
whereas13448903whe_reas
wheres125917443whe_re_s
whetters14246653whetters
wreakers15328423wreakers
yearners11346373_yearners

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.423422437.4
2DLD Change Limit1461624637.79618748.3
3Display Results4634630.1732676.3
 (SQL Overall)1786914638.39221293.0
 
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.