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

510 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
swearer1034995(None) 
searer65432021s_earer
shearer104414681shearer
smearer94110401smearer
spearer93913661spearer
swearers11328581swearers
sweater103712721sweater
wearer94319401_wearer
bearer85323912_bearer
clearer93710822clearer
dearer74822802_dearer
fearer94820182_fearer
hearer94323642_hearer
nearer64618892_nearer
rearer64928912_rearer
scarer84524602s_carer
sealer63928962s_ealer
seamer84223612s_eamer
seared75232842s_eared
seater64534152s_eater
serer55935502s_e_rer
sharer95025482s_harer
sheared114516002sheared
shearers113911322shearers
sheerer103813842sheerer
smeared104510622smeared
smearers10308622smearers
smearier1036952smearier
snarer64620842s_narer
sneaker112910452sneaker
sneerer73512312sneerer
soarer64522242s_oarer
sparer84524962s_parer
speaker133311212speaker
speared104314422speared
spearers103711142spearers
squarer163410662squarer
starer64027362s_tarer
stealer72913972stealer
steamer93313092steamer
steerer73113632steerer
sugarer837322sugarer
swager104013612sw_ager
sware85828212sw_are_
swarmer1247802sw_armer
swayer125210972sw_ayer
swear85316852swea__r
swears94114072swear_s
sweated113411542sweated
sweaters113811062sweaters
sweatier1147032sweatier
sweeper12329372sweeper
sweer84918572swe__er
sweeter103212002sweeter
sweller103012462sweller
swelter103711172swelter
swerver1365732swerver
tearer64822902_tearer
weaker134015442_weaker
weaner93816772_weaner
wearers104615902_wearers
wearier103613282_wearier
weaver123916612_weaver
afeared1176833afeared
aneared8512743aneared
answerer1144263answe_rer
awarder1135893aw_arder
aware86420023aw_are_
aweary1237303awear_y
aweather1434263aweather
barer74535803__barer
beader94623793_beader
beaker125520693_beaker
bearers94619593_bearers
beater84729393_beater
beaver114819253_beaver
besmearer1343163besmearer
beware11313713beware_
bewared13310113bewared
bewares12313373bewares
bleaker133510533bleaker
bleared104211253bleared
blearier1037333blearier
bleater94515303bleater
breaker133912923breaker
carer74942333__carer
cheaper144010583cheaper
cheater124816963cheater
cheerer123511753cheerer
cleaner93712303cleaner
cleared103612463cleared
clearers10349303clearers
cleaver124110803cleaver
creamer113714083creamer
creaser94415723creaser
darer65230793__darer
deader84220473_deader
deafer104114813_deafer
dealer74122143_dealer
dewater112912423dewater
dreamer104110843dreamer
drearier9297923drearier
dwarfer1433683dw_arfer
dweller11297273dweller
eager65526963__eager
eared65139503__eared
earner63617223__earner
eater54639843__eater
farer86733143__farer
feared106320433_feared
fearers104815273_fearers
feater95224053_feater
fuehrer1332973fuehrer
geared85317743_geared
gleamer10328513gleamer
gleaner8379773gleaner
greaser83913083greaser
greater84416493greater
header104422543_header
healer94221803_healer
heaper114119523_heaper
hearers104319783_hearers
heater94828303_heater
heaver124819673_heaver
jeerer13389933_jeerer
kneader1275893kneader
leader74824653_leader
leaker104620073_leaker
leaner64022193_leaner
leaper88118943_leaper
learier73415663_learier
learner7319383_learner
leaser65322673_leaser
leaver94321513_leaver
meager94515193_meager
meaner84617843_meaner
merer75126233_me_rer
neared75119803_neared
neater64424313_neater
parer75839903__parer
pearler9310373_pearler
pearter9412743_pearter
pleader103511753pleader
pleaser93912343pleaser
pleater93916333pleater
preaver121011613preaver
preparer12169643preparer
queerer16106503queerer
rarer54731703__rarer
reader73628293_reader
realer63528593_realer
reamer84325213_reamer
reaper84223143_reaper
reared75930013_reared
rearers74323563_rearers
reaver94524733_reaver
rewarder12208233rewarder
roarer63914333_roarer
saber75330243s__aber
safer84721813s__afer
sager65432053s__ager
saker95132023s__aker
saner54334323s__aner
saree55044663s__aree
savager1137133savager
saver84831253s__aver
savorer1057883savorer
sawer85026213s__awer
sayer84926553s__ayer
scaler84321603s_caler
scarcer113911373s_carcer
scare75334463s_care_
scared95227293s_cared
scarers94618503s_carers
scares85033003s_cares
scarey115016983s_carey
scarfer124511083s_carfer
scarier94017873s_carier
scarper114814823s_carper
scepter1138353scepter
scorer84818253s_corer
scourer93910433scourer
scraper114513413scraper
screamer12267873screamer
seabed95017693s_eabed
seafarer1144843seafarer
sealed74328363s_ealed
sealers74323553s_ealers
sealery104011053s_ealery
seamed94823883s_eamed
seamen84518563s_eamen
seamers94719433s_eamers
seamier93114633s_eamier
sear47353843s_ea__r
search113312423s_earch
searcher13209103s_earcher
searest73322023s_earest
sears54744913s_ear_s
seated75131053s_eated
seaters74028943s_eaters
secret8325063s_ecret
securer958253securer
sedater83713623sedater
seder64826753s_e_der
seeder74320773s_eeder
seedier83513633seedier
seeker103615363s_eeker
seemer84418043s_eemer
seepier92912013seepier
seer45547043s_e__er
seiner64622483s_einer
seiser65318343s_eiser
seizer154114573s_eizer
seller63824593s_eller
sender73824413s_ender
sere46153473s_e_re_
sered65737293s_e_red
seres55448893s_e_res
serger73819733s_erger
server94917713s_erver
setter64023723s_etter
sever85426053s_e_ver
severer103511563severer
sewage10310733sewage_
sewages1139753sewages
sewar85421093sewa__r
sewars94018623sewar_s
sewer84426213s_e_wer
sewered112911243sewered
sexier13310683s_exier
shader104218763s_hader
shaker134319463s_haker
shaper114119933s_haper
share86437083s_hare_
shared105829063s_hared
sharers104720623s_harers
shares95236413s_hares
sharker144313813s_harker
sharper124312703s_harper
shaver123718913s_haver
sheafed14388973sheafed
shear85424833shea__r
shears93820903shear_s
sheather1458233sheather
sheave124514003sheave_
sheaved143411633sheaved
sheaves134412973sheaves
shedder12339323shedder
sheer84726893she__er
sheered113515453sheered
sheeter103814913sheeter
sheller103515883sheller
shelter103214963shelter
shelver134211063shelver
shewer124515103she_wer
shoaler102610083shoaler
showerer1436163showe_rer
skater105015493s_kater
skeane104611373skeane_
skeanes113610713skeanes
skeeter113410413skeeter
skelter113610003skelter
skewer13519603ske_wer
slaker104219273s_laker
slater64429183s_later
slaver94419613s_laver
slayer93916333s_layer
sleave94714153sleave_
sleaved113611133sleaved
sleaves103813203sleaves
sleaze152611863sleaze_
sleazes162810333sleazes
sleazier1735123sleazier
sledder9399203sledder
sleeker11339823sleeker
sleeper93211563sleeper
slender83413593slender
smarter94113133s_marter
smear74416393smea__r
smears84714433smear_s
smeary114110803smear_y
smeller94212783smeller
smelter93311913smelter
snare54429983s_nare_
snared74824553s_nared
snarers74216663s_narers
snares65329033s_nares
snarler73610633s_narler
sneaked12329693sneaked
sneakers12308643sneakers
sneakier1245143sneakier
sneaped10338813sneaped
sneer54919953sne__er
sneered83113973sneered
sneerers8309803sneerers
sneerier878103sneerier
sneezer16237963sneezer
sneller73512843sneller
snorer64316763s_norer
soaker105717533s_oaker
soaper84517873s_oaper
soared74324293s_oared
soarers74118093s_oarers
soberer93110353soberer
socager10107703socager
soever94412093soe_ver
solacer93011103solacer
sorer56236583s__orer
sourer63620213s_ourer
spacer104917793s_pacer
spader94317133s_pader
spare75135563s_pare_
spared95427493s_pared
sparers94519613s_parers
spares84834553s_pares
sparger103613083s_parger
sparker133914363s_parker
sparser94311483s_parser
speakers14299453speakers
speaned103411523speaned
spear75821063spea__r
spearmen1234853spearmen
spears84019473spear_s
specter113111733specter
speeder103811073speeder
speer74623903spe__er
speered103614813speered
speired103811103speired
speller95415143speller
spelter94113703spelter
spencer113610973spencer
spender103713693spender
spewer115112143spe_wer
sprayer12369043sprayer
spreader1137473spreader
spurrer93710223spurrer
square154513363square_
squared173610563squared
squarers17338023squarers
squares163714463squares
squeaker2184883squeaker
squealer17115603squealer
stager74821343s_tager
staler64025823s_taler
stare54440263s_tare_
stared75429873s_tared
starers74522313s_tarers
stares66038753s_tares
starker114114693s_tarker
starter73817883s_tarter
starver104611993s_tarver
stater64427563s_tater
stayer94516483s_tayer
steaded92811673steaded
steadier937313steadier
stealers83412203stealers
steamed103712143steamed
steamers103410873steamers
steamier1048303steamier
stearic939423stearic
stearin7312003stearin
steeper93812773steeper
steer55423863ste__er
steered83615253steered
steerers82511353steerers
stemmer113210183stemmer
stepper113010853stepper
stere55328543ste_re_
stereo65317913ste_reo
steres63929533ste_res
sterner7411913sterner
stirrer7338233stirrer
storer64721673s_torer
strafer103912463strafer
strayer104312503strayer
streaker12229473streaker
streamer10239503streamer
suaver93014233s_uaver
subarea939403subarea
sugared938583sugared
sugarers936303sugarers
sugarier937393sugarier
surer54833093s__urer
svelter10359673svelter
swabber14297963swabber
swage94919563sw_age_
swaged114212253sw_aged
swagers114211023sw_agers
swages104417073sw_ages
swagger12389333swagger
swale85221593sw_ale_
swales93920763sw_ales
swamper14349313swamper
swanker14369483swanker
swapper14359703swapper
swaraj1636023sw_araj
sward94221463sw_ar_d
swarded1238153sw_arded
swards105415133sw_ards
swarf115324653sw_ar_f
swarfs125612063sw_arfs
swarm106218833sw_ar_m
swarmed1367483sw_armed
swarmers1346323sw_armers
swarms116112173sw_arms
swart86234643sw_ar_t
swarth126012083sw_arth
swarty125812383sw_arty
swasher134011513swasher
swather134213603swather
swatter104113323swatter
swayed133510263sw_ayed
swayers13398853sw_ayers
swearing123711443swearing
swearword1642343swearword
sweat85628403swea__t
sweats94814613swea_ts
sweaty123710053swea_ty
swede94413203swe_de_
swedes102711893swe_des
sweeney13387003sweeney
sweep104715723swe__ep
sweepers13348163sweepers
sweepier1355493sweepier
sweet85330523swe__et
sweeten10267313sweeten
swelled113211693swelled
swelters113110193swelters
sweltrier1242993sweltrier
swerve1256293swe_rve
swerved1455703swerved
swervers1455213swervers
swerves1377533swerves
sweven1235983swe_ven
swifter13318053swifter
swigger12338453swigger
swiller103211663swiller
swimmer14297653swimmer
swinger113812563swinger
swisher13369523swisher
swither133710993swither
swobber14336543swobber
swooner10358673swooner
swooper12389173swooper
swore84920813sw_ore_
swotter10399473swotter
teared75722153_teared
tearers75218233_tearers
tearier73815613_tearier
teaser65421523_teaser
theater104014253theater
treader84113833treader
treater74219833treater
tweaked1534403tweaked
tweakier1533143tweakier
tweener10306833tweener
tweeter10288533tweeter
tweezer19305763tweezer
uneager839753uneager
upbearer1243583upbearer
vealer94016543_vealer
wader95325363_w_ader
wafer114417643_w_afer
wager95925053_w_ager
waker125526593_w_aker
waler84229263_w_aler
warder104020273_w_arder
ware76254723_w_are_
wared96339873_w_ared
wares88250583_w_ares
warier93722893_w_arier
warmer113816733_w_armer
warner93717223_w_arner
warper114015583_w_arper
water84733313_w_ater
waver115025703_w_aver
waxer154317483_w_axer
weaken13349603_weaken
weaned103816153_weaned
weaners104613833_weaners
wear75836723_wea__r
wearied112911803_wearied
wearies103020223_wearies
wears86030303_wear_s
weary115620613_wear_y
weasel93410523_weasel
weather133513223_weather
weave115218533_weave_
weaved133913483_weaved
weavers133714463_weavers
weaves123616373_weaves
weber10313523_we_ber
wedder113612293_wedder
weeder103315513_weeder
weeper114313303_weeper
weer75535093_we__er
weever123811443_weever
weiner94214133_weiner
weirder1144923_weirder
welder102914413_welder
welter93417383_welter
were76238333_we_re_
wester94222893_wester
wether123315393_wether
wetter93919443_wetter
whaler124611973_whaler
wirer85124953_w_irer
wreaker143610043wreaker
yarer84321573__yarer
yearner10336873_yearner

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340275108.76615289.4
3Display Results5105100.1862741.9
 (SQL Overall)1786915109.10819619.1
 
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.